Importing Excel to Project RRS feed

  • Question

  • How do I import multiple (as in 100's) of assignment rows into MS Project 2010?  The import wizard only lets me import 1 Work record?  I have a record that shows:  ProjectName, ResourceName, Work1, Work2, Work3 - Work12; where Work is an hour allocation for a month.

    Tuesday, October 22, 2013 4:14 PM

All replies

  • HarvardProjectUser,

    It sounds like you are attempting to import timescaled data using the import wizard and the import wizard only works with static data (i.e. single value). To do what you want to do will require a VBA macro.

    However, depending on how the work is allocated each week, it may be possible to import the total task work content and then let Project spread it over the duration. If it's not quite the spread you need, you can then manually edit it but with 100's of assignments as you indicate that will be a long arduous effort. Personally I'd go with a VBA solution.


    Tuesday, October 22, 2013 6:25 PM