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