what would be the way to have a column return the last date another cell/same column was modified? Thanks
what would be the way to have a column return the last date another cell/same column was modified? Thanks
How about you attached a sample workbook with what you have and what you expect.
See "Yellow" banner
HTH
Regards, Jeff
You will need VBA to do this. Right click on the sheet tab and then paste the below on the right side of the screen. This will monitor B1 and when a change is made, A1 will show the date. Format A1 as a date.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks