ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to automtcly update th date in cell if info in row changes? (https://www.excelbanter.com/excel-discussion-misc-queries/68691-how-automtcly-update-th-date-cell-if-info-row-changes.html)

nycm

How to automtcly update th date in cell if info in row changes?
 
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 .

Max

How to automtcly update th date in cell if info in row changes?
 
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 .





All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com