Show date when amend excel sheet

[Closed]
Report
-
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
-
Hello,


How to set a formula, so that everytime I do a change in a cell or a cell range - todays date appear in a different cell.
In other words automatically show the date when a change was done on the particular excel sheet.

Appreciate help on this..

1 reply

Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
If you are entering data in Column A, The Date and TIME Stamp will be shown in Column C. You can either add a button and Assign a Macro or simply run this Macro to track the date of change.

Sub tryDateStamp()
Dim ColA, TestOut As Range
Set ColA = Range("A:A")
Set TestOut = Range("C:C")
itemCount = Range("A1").CurrentRegion.Rows.Count
For i = 2 To itemCount
If ColA.Cells(i, 1) <> "" And TestOut.Cells(i, 1) = "" Then
TestOut.Cells(i, 1).Value = Now
End If
Next i
End Sub

If you want to change the Range of input, the Range in the code needs to be changed.