Importing timephased data from Excel

[FeorMadrigal]

In Excel, I have rows containing timephased hours in columns by week with
tasks by row. I need to get this timephased data into MSP and I understand it
cannot be done with an import map. I would copy it into the resource usage
view, however, the view adds summary rows so the rows don't align. Any help
would be greatly appreciated.

 

[Rod Gill]

This can be done, but importing timephased data like this has many catches
and takes some time to iron all the bugs and user behavior into a usable
system. I can certainly help, but if you are new to VBA we are talking a
project spanning a number of weeks while we converse via email!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com