capturing cell value at a specific time

[Thomas Donino]

I need to capture the value of a cell at a specific time
of day in a dynamically updating spreadsheet? Anyone know
if that's possible and if so how to do it. Thank you.

 

[J.E. McGimpsey]

Take a look at an OnTime macro:


http://cpearson.com/excel/ontime.htm

If you're not familiar with macros, see David McRitchie's

Getting Started with Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm