Please advise if excel can have formula to register last change of another cell i.e. if cell A1 was retyped can cell A2 show date/time of that change ?

You can't do it with a formula, but you can do it with VBA. Right click the Sheet Tab for the sheet you are working with and choose View Code.

Paste this into the pane that opens.

Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Range("$A$2") = Now End SubEach time a change is made to A1, the Time and Date in A2 will update.

Thank you so much ! This was very helpfull and will save me some time when updating the price lists.

Thanks again and brgds

Ask Your Question

Weekly Poll