MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date stamp column


Posted by Kent on August 28, 2000 4:02 PM

I have created an excel 2000 sheet that contains mostly biographical data. I would like to have a column in each row 'stamp date' the date anytime ANY change in the appropriate row was made. I used to be able to this in a database program, but have not found the correct function/formula yet.

Thanks for your help!


Posted by Celia on August 30, 0100 9:04 PM


Kent

Private Sub Worksheet_Change(ByVal Target As Range)
Range("A" & Target.Row) = Now()
End Sub

Celia