Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Reigning in Seattle
 
Posts: n/a
Default How do I get one cell to record the time another cell was changed.

I know there's a simple solution to this, but I'm not seeing it. How can I
set up a cell to update the time (or date) whenever another cell has data
entered into it; e.g. cell A1 has new info entered into it, and cell A2
automatically updates the time of that update. Thanks in advance.
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

One way

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

Regards,

Peo Sjoblom


"Reigning in Seattle" wrote:

I know there's a simple solution to this, but I'm not seeing it. How can I
set up a cell to update the time (or date) whenever another cell has data
entered into it; e.g. cell A1 has new info entered into it, and cell A2
automatically updates the time of that update. Thanks in advance.

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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
how do i set up a single cell continual entry in excel to total f. mike@swallow Excel Discussion (Misc queries) 1 December 7th 04 01:29 PM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 03:48 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 01:07 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 01:07 AM


All times are GMT +1. The time now is 12:02 PM.

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

About Us

"It's about Microsoft Excel"