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

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

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