timestamp on each row...

[Guest]

how can I create a timestamp on each row in excel that updates per
change..like as a last modified date but instead of all changes make it row
specific

 

[Frank Kabel]

Hi
see:
http://www.mcgimpsey.com/excel/timestamp.html

 

[Guest]

On the module for the specific worksheet...

Private Sub Worksheet_Change(ByVal Target As Range)
Cells(Target.Row, 1).Value = Now
End Sub

This drops the time stamp in Column A.

Dale Preuss

 

[Ron de Bruin]

Hi

See J.E site for a example
http://www.mcgimpsey.com/excel/timestamp.html