Want to see same Text Field data from Task to Resource view

[Big_Bad_Yellow_Eskimo]

I have build up a system that uses ~ 25 MS project files. 1 of them is a
"Sharer Resource Pool". All the work I perform (analysis type) is done
through the resource file. Therefore, I use @ 90% of the time the Resource
Usage View. The people that uses the other files are mainly using the Gantt &
Task Usage view. In these views, there are 3 text columns that we use at all
time. 2 are formatted, the other is free text. When I work in the Resource
Usage View, I NEED to see the data entered in these columns. Can I see it and
if so HOW?

 

[JulieS]

Hi Big_Bad_Yellow_Eskimo

See FAQ 37 "Custom Fields in Tables" for information and a sample macro that
would populate data from Task custom fields to assignment custom fields.

Hope this helps. Let us know how you get along.

Julie

 

[Big_Bad_Yellow_Eskimo]

Thanks Catfish Hunter for the reply. Unfortunately, you did not understand
the question. The question is: the Text Column that you insert in a Task
View, can you see the data in the same Text Column but in a Resource Usage
view?

Regards,

 

[JulieS]

Hi again,

I assume it would help if I told you where to find the FAQ?

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

So sorry.
Julie

 

[Big_Bad_Yellow_Eskimo]

Hi Julie,

I looked for a while and did find it. However, to be honest, I did try the
Macro adapted for my specific needs and it doesn't work. I must confess that
I HAVE NEVER USED A MACRO until now! Here is what I tried:
PS: I'm trying to transfer data from Text28 field from a Task View to a
Resource view.

Sub TransferTaskText28ToResourceText28()
Dim t As Task
Dim r As Resources
On Error Resume Next

For Each t In ActiveProject.Tasks
For Each r In t.Resources
r.Text28 = t.Text28
Next r
Next t

End Sub

Can you direct me to an already defined Macro or tell me what's wrong with
this one?

Thank You.

 

[Jan De Messemaeker]

Hi Inuit,

It should "work" but are you aware that when the resource is allocated to
several tasks, only the text from the final task will prevail?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Big_Bad_Yellow_Eskimo" <[email protected]>
schreef in bericht

 

[JulieS]

Hi Big_Bad,

From your first post in this thread my understanding is that you want to
transfer data from a task Text field to a field that is available in the
Resource *Usage* view. I *think* that the problem with the macro below is
that you are trying to transfer Task TextX data to a Resource TextX field,
not an Assignment TextX field. (Again, my skills in VBA are *very* weak, so
this is only a guess.)

See the following link for a macro written by fellow MVP, Jack Dahlgren.

http://masamiki.com/project/copytaskfields.txt

I ran a test with the CopyTaskFields macro and it quickly transferred data
entered into the Text5 field in the Task Sheet to the Assignment Text5 field
visible that can be added to the Resource Usage view. I tested again with a
resource pool file and a project file connected to the pool. Running the
macro in the project file connected to the pool worked as well.

If you look at Jack's introduction page
http://masamiki.com/project/macros.htm
there is also some great information on how to install the macros that he
has created under the link "To Macro Installation"


Hope this helps. Let us know how you get along.
Julie

 

[Jan De Messemaeker]

Hi,

I just discovered an error.

Dim r as resource , NOT resources.
Reading Julie's post, if you want to taransfer the text to t's assignments,
change as follows:

Dim r as assignment
......
For each r in t.assignments