Hi... I have a value in a cell which is the percentage of work
completed in a day. This value changes automatically based on the
values in the other sheets. Say it is 30 % on 23-Oct-2008 and the
value is in cell D1.

Now, I am trying to create in the sheet something like this, (Say
today's date is 25-Oct-2008)

A B
23-Oct-2008 30%
24-Oct-2008 50%
25-Oct-2008 70%
26-Oct-2008 Pending
27-Oct-2008 Pending

Could you help me with a solution such that column B above,
automatically changes values "everyday" based on cell D1 value?

Thanks for your help.

Vicky