Excel project plans data integration into Microsoft Project file
Posted on 2013-10-30
I have excel files which currently are set up to be project plans by themselves. How can I integrate this excel data into a single Microsoft Project file (*.mpp). Ideally it would be able to sync itself back to the excel files but I'm not dreaming...
Please note the following :
-I cannot use the paste link method since I often add / remove tasks, etc. in the excel files and so I have a dynamic range, not a static one.
-I'm fine with importing the data each time the excel files change but I need to know how to do it, and I also have the following data to import :
Task Name | Resource Name | Predecessors | Start Date | Actual Work | Remaining Work | Actual Duration | Remaining Duration | Finish Date
The excel data includes tasks summary which I am able to determine directly in Excel by having a column that would act as the Outline Level (ie. 1, 2, 3, etc.) and so this needs to import fine as well.
How can I achieve the above?