Hi,
Hoping somebody could please provide some guidance. What I'm trying to achieve is below:
- I have daily dates cells L2:CH2
- To confirm when a cell task is completed, I'm putting in either an X or a time. So anywhere from cell L3 to CH3 there's an X or time.
- I want cell E3 to display when a task is due to be completed, so somehow it's got to read L3:CH3 and find the last filled out cell, then insert the due date from the corresponding cells L2:CH2.
- Some of the cells in L3:CH3 have multiple X/times, so I only want it to recognise the last cell in the row that was completed.
I'm thinking it's going to need to be VBA, but if someone knows how to do this, it would please be much appreciated.
Thanks,
Bookmarks