May be I need to explain the question better. Let;s us say that the
value in D3 changes very day at the 4 pm. I need to capture that value
on day 1 in b1 on day 2 in b2 on day 3 in b3 so on and so forth...so how
do I do that.....

Thanks


--
gumnaam00
------------------------------------------------------------------------
gumnaam00's Profile: http://www.excelforum.com/member.php...o&userid=16420
View this thread: http://www.excelforum.com/showthread...hreadid=277906

Hi
this would require VBA (using an event procedure). See:
http://www.cpearson.com/excel/events.htm

No way to achieve this with formulas alone


--
Regards
Frank Kabel
Frankfurt, Germany


gumnaam00 wrote:
May be I need to explain the question better. Let;s us say that the
value in D3 changes very day at the 4 pm. I need to capture that
value on day 1 in b1 on day 2 in b2 on day 3 in b3 so on and so
forth...so how do I do that.....

Thanks