Hello:
I have a spreadsheet where I want to record the start and stop times of certain events, and I thought it would be easy to add a quick script that would automatically put the date in for me. I was mistaken. I used the following script:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 2 Then
Target.Offset(0, -1).Value = Date
End If
End Sub
I wanted to make it so that when any data were added into Column B, the date would appear in Column A automatically. Can anyone assist me here?
Thank you
-Mike
I have a spreadsheet where I want to record the start and stop times of certain events, and I thought it would be easy to add a quick script that would automatically put the date in for me. I was mistaken. I used the following script:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 2 Then
Target.Offset(0, -1).Value = Date
End If
End Sub
I wanted to make it so that when any data were added into Column B, the date would appear in Column A automatically. Can anyone assist me here?
Thank you
-Mike