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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel to track expenses 1
problem with fractions to decimal 1
I need a macro to track the number of students enrolled per month 1
fomulas for tracking time entered text or data 1
How to finding student Rank and How to upload bulk marks of each student at a time. 1
if/then insert date but don't want automatic updates 7
Hide Values when data has not been entered into a cell. 2
multiple columns of data, reporting Means of specific combinations 4

Back
Top