Last Date a Record was Updated in Excel 2

[Wray69]

I have a spreadsheet that is a log of sorts that has many different records going down the spreadsheet. What I am looking to do is have a cell in each row that shows the date of when each row was last updated... Is this even possible?

Regards -

Wray

 

[Zathras]

Yes, you can do it with VBA, for example if your timestamp column is "E" (column 5) you can use this:

Option Explicit
Const TIMESTAMPCOL = 5
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
  If ActiveSheet.Type = xlWorksheet Then
    If Target.Rows.Count = 1 Then
      If Target.Column <> TIMESTAMPCOL Then
        ActiveSheet.Cells(Target.Row, TIMESTAMPCOL) = Now
      End If
    End If
  End If
End Sub

Hope this helps.

 

[Wray69]

Hey Zathras,

Thanks... That is exactly what I needed..

Regards -

Wray