Update a cell based on the pivot table refresh date

[syscrusher]

Hello,
I am trying to create an agile burn-down chart in excel 2007. I have a
datafeed to the project database and am creating a pivot table from the
resultant data. I am also able to extract the refresh date from the pivot
table. Here is the issue. I have created two columns from which the chart
will subsequently be created. Column A contains each day's date for the next
30 days. Column B should contain the remaining time-to-completion for the
project for that corresponding day. Taking into account the data and pivot
table will be refreshed daily, how can I update the value in column B from
the pivot table for that date only and prevent further modifications to that
cell? Thanks for any assistance provided.

 

[CyberTaz]

Although one of the local cross-platform Excel guru's may be able to address
this here you should be aware that you've posted to the Mac Excel news
group. You'll probably get a faster response if you post to one of the PC
Excel groups instead. You'll find them listed here:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[syscrusher]

Thanks Bob. I have used this resource often in the past, but this is my
first post here - and it shows. I appreciate the help.