LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default When was this cell updated?

That's basically what I want to know.

There are two cells, say d10 and d11, and I would like to know exactly when
they are changed. So I'd like to have a couple cells directly below them that
have the now() result entered into it if the cell above it is changed and to
have it updated each time those cells are changed.

I can do this easily in Access with an OnUpdate routine, but I am a complete
moron WRT coding in Excel. Any help is greatly appreciated.

Anyhoo...I've finally made the leap to Office '07 kicking and screaming.
After two weeks, I can't believe I waited so long. Pretty slick stuff.
Getting used to the interfaces was a challenge, but well worth it.

TIA...geoff
 
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
cell for date last updated houseman Excel Worksheet Functions 1 October 15th 08 05:05 PM
Excel cells randomly don't get updated unless each cell is updated Lost in Excel Excel Discussion (Misc queries) 5 September 29th 08 06:56 PM
Time or row cell updated 525047[_2_] Excel Worksheet Functions 2 March 23rd 08 10:09 PM
How do I have a cell display the date its row was last updated? castell Excel Discussion (Misc queries) 2 September 19th 06 04:43 PM
Cell Value Updated based cell input DC Excel Discussion (Misc queries) 2 August 17th 05 11:07 PM


All times are GMT +1. The time now is 03:42 PM.

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"