Hi,

How would i go about entering in the current dates information in the below spreadsheet.

So i have the information to enter into C:30, D:30 & E:30 but want the bot to be able to pick up the date for the correct row to input.

Hi,

How would i go about entering in the current dates information in the below spreadsheet.

So i have the information to enter into C:30, D:30 & E:30 but want the bot to be able to pick up the date for the correct row to input.

You will have to recalculate the row number (in your case 30) based on the 2 first columns;

If your date is 04/27 then extract the day (27) and add it to the row number of the 1st April in your sheet (2) which gives you 29

1 Like

Thanks for the reply, yes i was able to apply this solution.

Just wondering if there is an easier / more efficient way?

i m using VBA scripts for similar tasks. “excute macro” and put your data into arguments for macro.