Need To Show Resources Where Project Priority is Higher Than X.

[Fiona-NZ]

Hi,

I am using MS Project Standard 2003, and have a shared resource pool. I
have projects that have been prioritised, and only want to view the task
allocation for the resources for projects with a certain priority.

I can create a filter to only show tasks with a priority higher than 800,
but I cannot apply this filter to my resources.

Can I do this - or is there another way?

Thanks In Advance!
Fiona

 

[Rod Gill]

Hi,

The problem is that the Project Priority field belongs to the project and in
Resource Usage Views, you only see Resource and Assignment level data. The
only way I think you can resolve this, is a macro to copy the Project
Priority to an Assignment custom field such as Number1, for all assignments.
You could then filter the Resource Pool Assignment Number1 field for your
priority number.

The following macro should work on any active project. Copy paste it to any
Module in any project.

Sub CopyPriority()
Dim Tsk As Task
Dim Assign As Assignment
For Each Tsk In ActiveProject.Tsk
If Not Tsk Is Nothing Then
For Each Assign In Tsk.Assignments
Assign.Number1 = ActiveProject.Priority 'Copy project
priority
Assign.Number2 = Tsk.Priority 'Copy Task Priority
Next Assign
End If
Next Tsk
End Sub

I'm based in New Zealand as well so call me on 021 623 878 if you need help
with the macro.