Create an automatic date stamp in excel from an entry.
- by Obfus
I am trying to have a date stamp event happen in column B when an entry is made in column A. Now i can do this in VBA with no problem, the trouble i am running into is there is also a entry that will eventually go in say column D and would need a date stamp in column E as well. is this possible. here is a sample of the code i have used so far.
Private Sub Worksheet_Change(ByVal Target As Range)
For Each Cell In Target
If Cell.Column <= 3 Then
If Cells(Cell.Row, 1) < "" Then Cells(Cell.Row, 2) = Now
End If
Next Cell
End Sub