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