MULTIPLE DATE/TIME stamp

[ruben]

working on a log sheet which has column A for date/time IN and a column G for
date/time out. I will like column A to get stamped upon filling out column D
(locaction) and column G stamped when column E task is indicated. Is the
possible, been working on this for 2 days and I need some help, please
somebody.

 

[JMB]

Try this - right click on the sheet tab, select view code, and paste this
into the code window that appears.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False

If Target.Column = 4 Then
Range("A" & Target.Row).Value = Now
ElseIf Target.Column = 5 Then
Range("G" & Target.Row).Value = Now
End If

Application.EnableEvents = True

End Sub

 

[JMB]

Added a line so that that it will not overwrite the date/time stamp if
something is deleted from column D or E.

Private Sub Worksheet_Change(ByVal Target As Range)
If Len(Target.Value) = 0 Then Exit Sub
Application.EnableEvents = False

If Target.Column = 4 Then
Range("A" & Target.Row).Value = Now
ElseIf Target.Column = 5 Then
Range("G" & Target.Row).Value = Now
End If

Application.EnableEvents = True

End Sub

 

[ruben]

thank, I'll give a shot. I had DATE/TIME IN figured out, but the DATE/TIME
OUT was given a problem. Again thanks