go to the sheet's code page (right click the tab and select 'View code')
add this
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(Target.Row, "F") = Now
End Sub
** change "F" to whatever column that you want the date/time stamp in
Patrick
"spideylobster" wrote in message
...
Hi all.
I am looking for a way in Excel 2007 to have a cell which updates
every time I change the contents in that same row. So I have my
worksheet that has 12 columns. I want each row to have it's own date
stamp. So every time I update anything in a particular row, it would
put a date stamp in the last column of that row. I have seen macros
that are similar but I have had no luck implementing them. Can
someone help me please?
Sorry to sound like a nube but I could also use some help in how to
implement the solution.
~ Chad Watson