Date of entry

[Mark]

Dear Discussion Group
My supervisor wants to keep track of how much information I enter into a
spreadsheet everyday.
Is there a function so that whenever a type data into "A1", the date I did
this would appear in "A2."

Thank you,
Mark Joseph

 

[JE McGimpsey]

see

http://www.mcgimpsey.com/excel/timestamp.html

 

[Mark]

Dear JE McGimpsey,

Thank you very much. While I can't implement the directions, someone in my
IT department can.

Gratefully,
Mark Joseph Gallagher, Jr.

 

[Gord Dibben]

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row
If Target.Value <> "" _
And Target.Offset(0, 1).Value = "" Then
Target.Offset(0, 1).Value = Now
End If
End If
enditall:
Application.EnableEvents = True
End Sub

This sheet event code. Right-click on the sheet tab and "View Code".

Copy/paste into that sheet module.

As written works on column A only.


Gord Dibben MS Excel MVP

 

[Mark]

Thank you, Mr. Dibben. I will try to implement this.

Mark Joseph Gallagher, Jr.