Update Value Based on Date

Hi Everyone,

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:
A B
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.

Thanks,
Dave

@david.meehan The Explanation of the Problem faced is quite clear but is it possible for you to provide the two Input Files and the Expected Output File that you need? So that we can get a clear understanding of what needs to be done.

1 Like

Hi and Thanks for the Response.

I cannot upload files because i am categorised as a new user. I also think this means i cannot message you directly. Could you send me an inbox mail and maybe i can send through the files there?