I was doing some work in Project and Excel, and wanted you all to know about the following feature:
Exporting Project information to an Excel PivotTable
It might be something you want to play around with, as you are using both programs!
Open up your Project file in MSProject
Go to File, Save As
Under 'Save as type', choose "Excel Pivot Table", and click on Save
The Project Export Wizard opens up
Click Next
Click New Map
You have to create a map of fields from the project file to Excel field names
Click Next
Select which types of data you wish to export (tasks, assignments, resources)
Click Next
Create Map for data types
Click Finish
You may have to play with this to get what you're looking for, but I thought you'd be interested in knowing that this feature is available.
Good luck!
Corrine
No comments:
Post a Comment