Import/export resource usage data from Project to/fro Excel? Help

L

Laura

I want to manage Resources by Project by Month with % Allocated in Excel and
then to load the data into Project. I want the spreadsheet to look like the
"Resource Usage" view. I can't find a map to make this work. Any advice?
 
G

Gérard Ducouret

Hello Laura,
Only a VBA procedure (not a very simple one) can do that.
Conversely, the export of Project data to Excel would be easy : in the
Analyse tool bar Clic the "Analyse timescale data to Excel..." button

Gérard Ducouret
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resource Budget Cost - Tracking 0
Using project as a resource tracker 0
Export resource information 2
Resource graph/total for a filtered set of tasks 0
changes in resource usage view 3
Master Project Resource Graph 2
resource leveling and over allocation 2
Resource Work Load 0

Top