DateTime in B only if B is empty then ? Put in the worksheet module:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cel As Range
For Each cel In Target
If cel.Column = 1 Then
If cel.Offset(0, 1).Value = "" Then
cel.Offset(0, 1).Value = Now
End If
End If
Next
End Sub
HTH. best wishes Harald
"AntonyY" skrev i melding
...
Hi Harald
In column A a person will enter there initals, at this point in column
B I will need the time stamp of when this happens. The reason I need it
hardcoded it that if somebody makes a mistake and puts there inital in
the wrong row it will change the time. Then I've lost the real time
that, that person arrived.
Regards
Antony
--
AntonyY
------------------------------------------------------------------------
AntonyY's Profile:
http://www.excelforum.com/member.php...o&userid=16690
View this thread: http://www.excelforum.com/showthread...hreadid=320467