Show date when amend excel sheet
Closed
abc123
-
Apr 25, 2012 at 09:25 AM
Mehedad Posts 22 Registration date Thursday April 19, 2012 Status Member Last seen April 16, 2013 - Apr 26, 2012 at 05:53 AM
Mehedad Posts 22 Registration date Thursday April 19, 2012 Status Member Last seen April 16, 2013 - Apr 26, 2012 at 05:53 AM
Related:
- Show date when amend excel sheet
- Excel date format dd.mm.yyyy - Guide
- How to screenshot excel sheet - Guide
- Mark sheet in excel - Guide
- Little alchemy cheat sheet - Guide
- How to open excel sheet in notepad++ - Guide
1 response
Mehedad
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
Apr 26, 2012 at 05:53 AM
Apr 26, 2012 at 05:53 AM
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.
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.
