Results 1 to 3 of 3

Thread: Resource Usage View - adding columns only available in Task Views

  1. #1
    Join Date
    Oct 2005
    Posts
    93

    Resource Usage View - adding columns only available in Task Views

    I am trying to do "Exporting of Data through Resource Usage View" post is doing and I am also using the resource usage view to move tasks by resource to Excel. But I have been asked for additional information for each Resource View in Excel by the PM. That information is on the Task Views and is total "resources" on task, total "work" hours estimated, the "Notes" and a "Text" field from the Task View, all on one line by task in Excel. It will be useful to get that summary task line too, but I am not able to figure out how to get it in the Resource Usage View. I want to know if there's a way to do this in or out of project without any problems. It's the combination of the Resource Usage view and the Tracking Gantt (plus some fields) that's causing me grief. The final goal is an Excel tab for each resource with all the above information. Thanks for any information.

  2. #2
    Join Date
    Jan 2006
    Posts
    2,257

    Re: Resource Usage View - adding columns only available in Task Views

    I think that you are not using Project 2007 because that version has expanded capability for getting Project data into Excel via Visual Reports. You can try to go the below link and check out some information on Data Types: Task, Resource and Assignment -

    http://www.mvps.org/project/faqs.htm

  3. #3
    Join Date
    Sep 2009
    Posts
    1
    I saw the response, have a similar challenge, and didn't find her solution posted. I want to add custom text to the Resource Usage field. Are there commands to make text appear in the resource report? If so, what are they?

    I don't know why you can't see it. Pam's question is on this same page: Resource Usage View - adding columns only available in Task Views
    I am trying to add custom text fields to the Resource Usage Report table. The Usage report however doesn't recognize Task fields. Is there some way to redirect the usage table to accept Tasks fields? John referenced using VBA. What commands/format and where would they be used?

Similar Threads

  1. Resource Usage View
    By shoppingboy in forum Microsoft Project
    Replies: 5
    Last Post: 25-04-2012, 06:01 PM
  2. Replies: 6
    Last Post: 24-09-2011, 01:32 AM
  3. Task Usage View to MS Excel...?
    By darkdimension in forum Microsoft Project
    Replies: 4
    Last Post: 17-09-2011, 03:14 AM
  4. Summarize Task on Resource Usage View/Reports
    By Deabelos in forum Microsoft Project
    Replies: 3
    Last Post: 08-01-2011, 06:07 AM
  5. Resource usage view
    By CBnation in forum Microsoft Project
    Replies: 2
    Last Post: 07-10-2010, 04:24 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,244,907.00678 seconds with 17 queries