Hi,
I am looking for a code to auto-update date when data is entered in a specific column. currently i am using a code which is sucessfull in filling up my desired column. but i would like to enter another column of date which is automatically updated when data is entered in another column. so basically i am looking for 2 columns that get autofilled with date when their respective columns data is entered.
original code used -
Private Sub worksheet_change(ByVal target As range)
If target.Column <> 4 Then Exit Sub
If target.Cells.Count > 1 Then Exit Sub
With target.Offset(0, 3)
.Value = Now
.NumberFormat = "DD/MM/YYYY"
End With
End Sub
thank you