Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identifying updated cells
I have a resource file with about 20 columns and 400 rows (resources). As
resource changes occur, the file gets updated (not frequently, but maybe 1/2 dozen resource changes occur per week). Is there a way to automatically enter a date into a new column that identifies when any of the data changed for a resource row? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identifying updated cells
Yes, with a little VBA:
Let's use column U (column #21) for the date-tag: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns("A:T")) Is Nothing Then Exit Sub End If n = Target.Row Cells(n, "U").Value = Format(Now, "mm-dd-yyyy") End Sub To use this macro, right-click the tab name at the bottom and select View Code Then just paste the macro in. -- Gary's Student "MLK" wrote: I have a resource file with about 20 columns and 400 rows (resources). As resource changes occur, the file gets updated (not frequently, but maybe 1/2 dozen resource changes occur per week). Is there a way to automatically enter a date into a new column that identifies when any of the data changed for a resource row? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identifying updated cells
Wonderful! Thank you very much.
MLK "Gary''s Student" wrote: Yes, with a little VBA: Let's use column U (column #21) for the date-tag: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns("A:T")) Is Nothing Then Exit Sub End If n = Target.Row Cells(n, "U").Value = Format(Now, "mm-dd-yyyy") End Sub To use this macro, right-click the tab name at the bottom and select View Code Then just paste the macro in. -- Gary's Student "MLK" wrote: I have a resource file with about 20 columns and 400 rows (resources). As resource changes occur, the file gets updated (not frequently, but maybe 1/2 dozen resource changes occur per week). Is there a way to automatically enter a date into a new column that identifies when any of the data changed for a resource row? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Updated cells | Excel Worksheet Functions | |||
Identifying Cells with formulas | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |