timestamp on each row...
 

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

timestamp on each row...
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Starrpro50" schrieb im
Newsbeitrag ...
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

timestamp on each row...
 

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

"Starrpro50" wrote:

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

timestamp on each row...
 

Hi

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Starrpro50" wrote in message ...
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