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

"ruben" wrote:

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.