Bright01
asked on
Last Update Date
I have a spreadsheet and each time I open it it displays the current date. I'd like a command or small macro that places in the cell below the current date the date the spreadsheet was last worked on. If I use a simple copy/paste, it too will auto update each time I open the sheet. Just to be clear, when the sheet is closed and then reopened a new date time will be established and the old one moved into the "date spreadsheet was last worked on".
Hard or easy?
B.
Hard or easy?
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh and of course change "sheet1" and "A1" to reflect the sheetname and cell that you want the date stored in.
ASKER
Neilsr,
I'm not sure what I'm doing wrong..... I cut/pasted your code into the Company_Profile tab in the Developer's tab, changed the spreadsheet name and the cell reference and saved/closed the workbook. When I opened it....nothing. I'm running 2010 if that makes any difference and I do have macros enabled............ any ideas?
B.
I'm not sure what I'm doing wrong..... I cut/pasted your code into the Company_Profile tab in the Developer's tab, changed the spreadsheet name and the cell reference and saved/closed the workbook. When I opened it....nothing. I'm running 2010 if that makes any difference and I do have macros enabled............ any ideas?
B.
ASKER
Oh... changed it to "This Workbook" and it worked great! Much thanks.
B.
B.
ASKER
By the speed and simplicity, I'll take it as a "yes" that was easy!
Thanks,
B.
Thanks,
B.
Developers tab, visual basic, paste code into This Workbook
Glad to be of help