How to save project by resource in different excel sheets?

B

bradys28

I have 12 resources in my project and have them sorted on the task summary by
resource. My PM wants all of the information saved in different sheets in an
Excel workbook, and each sheet needs to be a different resource name. How do
I save project in different excel sheets by resource name?
 
J

Jim Aksel

Filter the data before exporting to excel creating a separate Excel file for
each resource. The resource usage view would be excellent for this purpose.

The excel files can then be combined in Excel by importing or via Copy/Paste
to new work sheets.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
 

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 name inside resource sheet: per person, work per hours per week 0
Resource Budget Cost - Tracking 0
How to implement two shifts per day with multiple teams 0
How to create visual report that combines resource remaining workacross multiple summary tasks 0
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Resource graph/total for a filtered set of tasks 0
Base calendar interaction with a resource calendar 0
Excell Otpions in office environment 0

Top