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

S

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)
 
P

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
 
J

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
 

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

Top