Macro or formula to date stamp cell based on new data input

[spideylobster]

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
(e-mail address removed)

 

[Patrick Molloy]

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

 

[Jacob Skaria]

Time Stamp in 13th column. Right click on the sheet tab-->View Code and paste
the below code. You can also set the font color of col 13 to white to hide
the timestamp for the user.

Private Sub Worksheet_Change(ByVal Target As Range)
Cells(Target.Row,13) = Now()
End Sub