A Way to list the WBS number with each task in resource usage view

[DTScheduler]

Hi -

Help! I am preparing a resource assignment list using the Resource Usage
View. I am copying and pasting from MS Project Resource Usage View to Excel.

I want to show for each person a list of their assignments listing WBS,
Resource Name, Remaining Work and Start date. I can get all of those columns
to show in Resource Usage View except for WBS. I can show ID from the Gantt
chart but not WBS. Is there any common field from the Gantt view that will
show in the Resource View even if I have to manually enter the WBS numbers so
I can get the WBS number to show?

Most appreciated.

 

[Mike Glen]

Hi DTScheduler ,

Welcome to this Microsoft Project newsgroup

You might like to see FAQ Item: 37 - Custom Fields in Tables. FAQs,
companion products and other useful Project information can be seen at this
web address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on

Mike Glen
Project MVP
..

wrote:

 

[Jan De Messemaeker]

Hi Lisa,

This macro should copy the WBS values into the assignments' Text1 field that
can be shown in any Usage view:

Sub CopyWBS
Dim Job as task
Dim Whodunit as assignment
for each job in activeproject.tasks
if not job is nothing then
for each whodunit in job.assignments
whodunit.text1=job.wbs
next whodunit
end if
next job
end sub

HTH