Hi Im trying to add code so when a user enters data into Cells A, B, C and D the Date and time is populated in Cell E.
I have a code which actions this request when either of these 4 cells have been changed singularly but was wondering if this could be done if only all 4 Cells have data entered into them and then if deleted from them all the stamp is also deleted.
If anyone able to help?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Application.EnableEvents = False
Cells(Target.Row, 5).Value = Date + Time
Application.EnableEvents = True
Thanks in advance