Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
nycm
 
Posts: n/a
Default 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 .
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default 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 .



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Update a cell with a specific value related to a date. Jeff Excel Worksheet Functions 5 December 9th 05 06:14 PM
Date Range within one cell Cachod1 New Users to Excel 5 October 18th 05 03:30 AM
How to update a cell if a specific date is included in a date rang mgavidia Setting up and Configuration of Excel 2 October 8th 05 12:53 AM
update a date cell only when worksheet is edited Joe Black Excel Discussion (Misc queries) 1 September 23rd 05 05:11 AM


All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"