I am trying to enter a timestamp in column B when data is entered in column A. If column B changes, I’d like the timestamp to change. I have the following code, but it is not working (I am new to this…).
Sub Timestamp()
If Target.Column = 1 And Target.Offset(0, 1).Value = "" Then
Target.Offset(0, 1) = Format(Now(), "HH:MM:SS")
End If
End Sub
Sub Timestamp()
If Target.Column = 1 And Target.Offset(0, 1).Value = "" Then
Target.Offset(0, 1) = Format(Now(), "HH:MM:SS")
End If
End Sub