How can I keep track of when (date and time) data is entered into.

M

Mike C.

I am trying to create a spreadsheet for a high school class. I need to be
able to track when a student has entered data into specific cells of the
spreadsheet. Any ideas?
 
J

Jack Schitt

In the code behind the worksheet, enter (eg)

Private Sub Worksheet_Change(ByVal Target As Range)
Cells(1, 1).Value = Now()
End Sub

This will enter in Cell A1 the date and time at which any entry is made in
that worksheet.
If you need the location of the time-stamp to vary according to which cell
is changed then you can test the value of Target and vary the destination
cell accordingly.
 
Top