Hi I require a formula to show the time stamp of the last updated eg. a change is made in any cell. if that is not possible by excel formula, then would there be one to show time stamp for last saved.
Hi I require a formula to show the time stamp of the last updated eg. a change is made in any cell. if that is not possible by excel formula, then would there be one to show time stamp for last saved.
Hi @ Shamz41
The easiest way to do this is using a Worksheet Change Event.
If you want to deal with VBA, paste the following code in your Worksheet Module,
change the sheet names, according to your own workbook
With this, any time you change the content in any cell in Sheet1,Please Login or Register to view this content.
you will get the time stamp in the corresponding cell in Sheet2
Barriers are there for those who don't want to dream
FORMULA:
Creating a timestamp with a formula is tricky because a formula's value updates every time the workbook recalculates.
Here is a link showing how to create a once-off timestamp
- it does not do what you want this time, but explains the problem and may be useful for something else
VBA:
@vichopalacios suggestion is better than trying to use a formula
if you are "sharing" workbooks this would allow you to see who made the change
if a user inserts a column or a row, then the sheet containing the timestamps will put an entry in every cell in that column(down to row 1048576) or that row (out to column XFD)Please Login or Register to view this content.
- simply add a couple of lines to delete those excessive rows and columns
Please Login or Register to view this content.
Last edited by kev_; 09-10-2017 at 05:41 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks