Hello there,
To achieve this select the tab for the worksheet you want the datestamp to be stamped on when the worksheet is updated.
Then rightclick on the tab and select View code.
Paste the below code in the space provided.
Anything that appears in green is a comment.
You can then exit out of VBA
You may need select a new number format for cell G1 to have it correctly display the information. I had to select More Number formats and then the Date category and then 3/14/01 1:30pm.
Let me know if this works for you!
Thanks!
Bookmarks