time stamp for last updated entry in cell

[Shamz41]

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.

[vichopalacios]

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

Please Login or Register  to view this content.

With this, any time you change the content in any cell in Sheet1,
you will get the time stamp in the corresponding cell in Sheet2

[kev_]

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

Please Login or Register  to view this content.

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)
- simply add a couple of lines to delete those excessive rows and columns

Please Login or Register  to view this content.