Auto insertion of date and time

M

MC

I'm trying to build a spreadsheet to log support calls, all i need is a way
of inserting the time & date in a column as soon as data is entered in
another column. I have done this using the Now() function but the date &
time keep updating, I want them to remain the same as when the first
appeared.

I have a bit of VB knowledge so am happy to do it this way if required.

Any ideas?


TIA,

MC
 
D

Don Guillett

From a post I sent to someone yesterday

right click sheet tab>view code>insert this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 4 And Target.Column = 3 Or Target.Column = 4 Then
Cells(Target.Row, "a") = Date
Cells(Target.Row, "b") = Time
End If
End Sub
 
Top