I am very new to RPA and I am trying my best to find a solution to my problem, but I am yet to find one so I thought I would ask.
I am attempting to build a bot that will take a value from a cell in the sheet “Holdings” (which is updated daily through capital IQ) and paste the value in a cell on the sheet “Returns”. I want the value to be pasted directly below the previous date value such as:
Row 1: 12/04/2020 - $100
Row 2: 13/04/2020 - $101
Row 3: 14/04/2020 - X
I can easily copy and paste the value, but how do i make the bot paste below the previous entry.
Any help is greatly appreciated.