I’m having an issue writing a variable into the next empty cell.
I need to get numeric date out of SAP every morning and put it in the right field in column B. So for 1st of April I want it to automatically fill in Cell B458. Then when I want to run the robot tomorrow it needs to fill it in in B459 etc. I created a variable for the SAP data so all I need is a formula to copy it in the next empty cell.
I checked the other topics about this on the forum but both read range and write cell don’t seem to work. Can anyone help?