Need to put data in a new cell at close of market.

[gumnaam00]

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

Thank

 

[Frank Kabel]

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