Pulling data from one project file into another project file
My office is using Project is what I think is a rather non-standard way, so hopefully this makes sense.
We have files for multiple sites (about 25 of them) and each one is used to track a risk assessment process for that site, with 9 milestones and several other smaller tasks. We are using the Project Overview report to show a percentage complete with each site.
My boss is now asking for a big roll up document that would essentially pull that percentage complete and what the last completed milestone was along with a start and finish date. I have zero clue how to make that happen without just typing it all in manually. Is there a way to automate that in a new file?
Should I maybe look at consolidating these into a single file? Your wisdom and advice is welcome.
|