Excel input by date given

[Automater999]

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.

[Sofiane_Sahir]

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

[Automater999]

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

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

[Ivanco]

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