Thread: How to insert update date

1. Switch to visual basic editor.
2. Click on the name of your sheet in project explorer at your left.
3. On the right pane select "Worksheet" from the left drop down and select "Change" from the right drop down.
4. Now you are in the Worksheet_Change event.
5. Copy this code between "Private Sub Worksheet_Change" and "End Sub".

Code:

Col = Left(Target.Address, 2)
If Col = "$A" Then Target.Offset(0, 1) = Now

Now whenever you change a cell in column "A" the next cell in column "B" will be updated with date and time.

Related Link:
http://www.exceldigest.com/myblog/20...ined-function/

Please let me know if you get the expected result.

You are welcome.

Thanks for your reply.