Hi guys, need help in a what seems to be simple problem,
In a worksheet I have 6 cells B7, E7, F7 etc. which are data validation cells. They are in a list form consisting of date values. I run a macro which updates the date values everyday in the list, to compare data between different dates.
Lets say current date in validation cell B7 is 22nd of july, when i update the dates the latest as of today should be 23rd of July.
However by default the date on B7 is still 22nd of July unchanged, so now what I need is a macro that will select the latest date on that cell from the cell validation list.
Thanks.
Bookmarks