date-stamping a cell's data

  • Hi,

    I'm wondering if there is a way to put a date stamp on cell data. I have a spreadsheet of client contact data that multiple people might update. Ideally I would like to be able to look at the data in the cell (like an address for instance) and have it also show the date on which the address was entered. That way, if a client gets a new address and one person update it, the others will know that it is current. And, if possible, I would like to have this function be enabled automatically - i.e. the person changing the data would not be responsible for entering the formula. Namely, they would just enter the information and the date stamp would be enabled automatically.

    I'm using Windows 2000 and Excel 2000 if that makes a difference.

    Any help will be appreciated!

  • You could write a VBA routine that checks to see if any (or selected) cells have been changed, and then, if so, writes the current date/time into the comment of that cell.

  • Thanks for your reply! Unfortunataely, I'm not familiar with VBA routines - could you point me in the direction of any online instructions perhaps?

  • this simple routine should work....

    assume your addresses are in column B (2nd column) and you want the last_update field in column C (1 to the right)

    just put this short macro in the sheet module :

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    If Target.Column = 2 Then
    Target.Offset(0, 1).Value = Date
    End If
    End Sub

    (or right click the sheet tab, click "view code" and paste it in there)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!