i am working on a process which is going to run daily.
I have a Excel Worksheet with multiple rows + one colum for each date. In the process I am finding a value which needs to be written in a its relevant line and for the current date.
in cell A2 we have “CompanyA” in B1 we have the date column. Todays value for CompanyA is 2 so it needs to written into cell for CompanyA and the Coulm for today.
Do you have a clever idea how it could work?
Thanks and best regards