Show date when amend excel sheet
Closed
abc123
-
25 Apr 2012 à 09:25
Mehedad Posts 22 Registration date Thursday 19 April 2012 Status Member Last seen 16 April 2013 - 26 Apr 2012 à 05:53
Mehedad Posts 22 Registration date Thursday 19 April 2012 Status Member Last seen 16 April 2013 - 26 Apr 2012 à 05:53
Related:
- Show date when amend excel sheet
- How to screenshot excel sheet - Guide
- How to copy data from one excel sheet to another - Guide
- Excel hyperlink to another sheet - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Sheet right to left in google sheet - Guide
1 response
Mehedad
Posts
22
Registration date
Thursday 19 April 2012
Status
Member
Last seen
16 April 2013
3
26 Apr 2012 à 05:53
26 Apr 2012 à 05:53
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.
