Hi!
I am trying to figure out a way to track any changes for a row in the first column.
I would like the date of the change to pop up in Column A if anything in that row was changed.
A formula or VBA is fine. I have seen similar code, but I don't quite understand the code to change it to what I want. Here is one sample I found.
If you change column 3 puts date in column 4 or change column 8, date in column 9:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Or Target.Column = 8 Then
Application.EnableEvents = False
Target.Offset(0, 1).Value = Date
Application.EnableEvents = True
End If
End Sub
I am trying to figure out a way to track any changes for a row in the first column.
I would like the date of the change to pop up in Column A if anything in that row was changed.
A formula or VBA is fine. I have seen similar code, but I don't quite understand the code to change it to what I want. Here is one sample I found.
If you change column 3 puts date in column 4 or change column 8, date in column 9:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Or Target.Column = 8 Then
Application.EnableEvents = False
Target.Offset(0, 1).Value = Date
Application.EnableEvents = True
End If
End Sub