How to auto update time after any change

[sanjeev kumar]

Dear Chandoo,
I am attaching my excel file herewith.
how to show time and date if we do any change. I have done some work, plz check and make the sheet better.

 

[Abdul Matheen]

Hi Sanjeev,

Where you need to update the date and time if any changes made, do you want to track the changes if made in any of the sheet or only a particular sheet? Brief the requirement.

Regards
Abdul Matheen

 

[sanjeev kumar]

I want to t Track the changes made in any of the sheet and the time update should be on first sheet.

Hi Sanjeev,

Where you need to update the date and time if any changes made, do you want to track the changes if made in any of the sheet or only a particular sheet? Brief the requirement.

Regards
Abdul Matheen

 

[Deepak]

Hope! you are looking something like this.

Paste it in worksheet module from where you want to detect changes.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target <> "" Then Sheet1.[B4] = Now
End Sub