Show date when amend excel sheetClosed

Question

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..

Mehedad · Answer

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.

Show date when amend excel sheet

1 reply

Subscribe To Our Newsletter!