Try JE's "DateTimeStamp Macro" at his page:
http://www.mcgimpsey.com/excel/timestamp.html
(Scroll down the page a bit to that part)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nycm" wrote in message
...
Is there a way that I can have the date in one cell automatically update
if
any info in that row is adjusted? ie column a is "date updated" and if in
row 1 I update any info, the date will automatically adjust in row 1
column a
to the date that I updated the info .