Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or formula to date stamp cell based on new data input
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or formula to date stamp cell based on new data input
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or formula to date stamp cell based on new data input
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 -- If this post helps click Yes --------------- Jacob Skaria "spideylobster" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Stamp in one cell when data in other range changes | Excel Programming | |||
run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
date stamp based on word input. | Excel Programming | |||
input a date or update it based on date in another cell | New Users to Excel | |||
Can excel have a button to input (stamp) the systems date and/or . | Excel Worksheet Functions |