Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Location
    Rio Rancho, New Mexico, USA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rollup of Resources (2002)

    I am trying to setup and export to Excel that will allow me to roll-up resource usage to the next level or higher. If I do the roll-up by only showing certain levels and copying data, it will not break out the resources if there is more than 1 assigned to a task. I want to separate these into separate lines in Excel so I can sort for import into another program.

  2. #2
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rollup of Resources (2002)

    Are you talking about Resource Usage or Task Usage. Your post references Reource Usage, and your description sounds like Task Usage.

    Carla

  3. #3
    New Lounger
    Join Date
    Feb 2005
    Location
    Rio Rancho, New Mexico, USA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rollup of Resources (2002)

    I want to be able to pull the hours out assigned to each resource for each task separately. If I have 3 resources assigned to 1 task, I need to be able to create a line in Excel for each resource to include the task number.
    1.1.1 Resource 1 3.0 hrs
    1.1.1 Resource 2 3.5 hrs
    1.1.1 Resource 3 1.5 hrs

    Make sense?
    It has to do with being able to import these individually into Micro-Frame Program Manager.

    Randy

  4. #4
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rollup of Resources (2002)

    Hi Randy,

    I could not find a way in Project to give you the information as you have it listed. I was able to take the Task Usage data into Excel and in Excel get the list you are looking for. If this works you could record the steps into a macro in Excel so you would not have to manually repeat the process each time. Here are the instructions using Excel 2002 and Project 2002:

    Go to Task Usage view, Usage Table
    Right Click on the Task Name column and select Insert Column and add the field WBS
    Select the table and copy the data
    Go to Excel and paste the data
    In Excel delete the columns for Duration, Start and Finish (Columns E, F and G)
    Select column B (the WBS) and from the smart tag choose Convert Text to Number
    Copy column B and past it into Column A
    Select column B and from the menu bar select Edit Go To
    In the Go To dialog box click the Special button in the lower left
    Select the Blanks radio button and click OK
    Type = and press the up arrow key and press the keyboard combination Ctrl + Enter. This will fill in the WBS column and eliminate the blanks
    Select Column A
    Select from the menu Edit Go To
    In the Go To dialog box select the Special button in the lower left
    In the Go To Special dialog box select constants and click OK
    Select from the menu Format Row Hide

    If you have additional questions or the instructions are unclear please post again.

    Carla

  5. #5
    New Lounger
    Join Date
    Feb 2005
    Location
    Rio Rancho, New Mexico, USA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rollup of Resources (2002)

    You are way too smart to be dealing with my minor issues! Thanks for your help. It was extremely effective.

    Randy

  6. #6
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Rollup of Resources (2002)

    Randy,

    If you search past posts, I believe I have one that has the VBA to export this data directly to excel. Post back if you cant find it.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •