View Single Post
 
Old 01-12-2021, 09:42 AM
miless2111s miless2111s is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

you can set up a new table and view in MS project which will have the same columns as your excel which will allow you to copy from the Excel into the Project. However it wouldn't make sense to maintain both Unless the excel is providing an "off plan" method of tracking progress which then needs to be fed back into some summary line in the MSP plan? I sometimes do this when there are a lot of independent tasks which would be a pain to constantly change in MSP; for instance the team may have 200 Procedures to update and have calculated the total time needed to do this and are tracking progress against a 200 row spreadsheet and the Excel sheet kicks out the % complete and start/finish dates to be entered into MSP. The excel tracker provides the burn down charts etc which show if the team is winning or behind on the detailed tasks...
Reply With Quote