How to copy task-fields over to assigment-fields

[Anders]

My original discussion entry seem to have been forgotten
so I'll just "re-post" it - hope that's OK...

I would like to display information/fields stored
under a seperate task (e.g. Text1) to be dispalyed in an
assigment wiev. This means that the task field Text1 must
somhow be linked to the resource field Text1. Is this
prossible or do I have to write every piece of
information twice?

Thanks in advance!

/Anders


Clarification:
There is only one resource per task (working part time)
but one resource works on many tasks. The problem is that
I want more than one task field to be visable when
looking at the resource usage - it is simply not possible
to distinguish between seperate tasks only by the task
name.

I use MS Project for production scheduling and have over
1000 tasks but only a few resources to manage. It is thus
impossible to hard copy the information I want to
transfer as you suggest. How can the VBA routine be built
and imported to MS Project? Basically, I want to
transfer text fields specifying for instance the part no.
of the product produced.

/Anders

 

[Jack D.]

Anders,

Jan has posted a vba routine which would do this for you.
If you tell us specifically which fields you want to show and which view you
want them to show in someone will very likely give you the exact code that
you need.
If you give detailed information about what EXACTLY you want to do, it is
easy to give an answer.

-Jack

My original discussion entry seem to have been forgotten
so I'll just "re-post" it - hope that's OK...

I would like to display information/fields stored
under a seperate task (e.g. Text1) to be dispalyed in an
assigment wiev. This means that the task field Text1 must
somhow be linked to the resource field Text1. Is this
prossible or do I have to write every piece of
information twice?

Thanks in advance!

/Anders


Clarification:
There is only one resource per task (working part time)
but one resource works on many tasks. The problem is that
I want more than one task field to be visable when
looking at the resource usage - it is simply not possible
to distinguish between seperate tasks only by the task
name.

I use MS Project for production scheduling and have over
1000 tasks but only a few resources to manage. It is thus
impossible to hard copy the information I want to
transfer as you suggest. How can the VBA routine be built
and imported to MS Project? Basically, I want to
transfer text fields specifying for instance the part no.
of the product produced.

/Anders

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++

 

[Jan De Messemaeker]

Hi again,

Since you resubmit your question, I'll resubmit my answer but I'll give some
more explanation.

In the Task Usage View, Copy the task text1 to the

Assignment text1
Go to Tak Usage view
Make sure the detail lines (wich are assignment lines) are visible
Insert a column Text1
For each task, select the text1 cell and the assignment text1 cells
depending from that task
Ctrl+D (Copy Down)

Alll assignment fields now have the same value in Text1 as the parent task
has in his text1 field

That will in turn be visible in the resource usage view

So it answers your question doesn't it?

The alternative is a VBA routine;
Have you thought about how to handle multiple resources on a task? and
multiple tasks for a resource? Which text is transferred?

Have you??

HTH



--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Anders]

Hi! Thanks for your interest in helping me out. Below you
can find further details that I hope is sufficient for a
continued discussion.

I understand the concept of copying the textfield from a
task to an assigment textfield. And yes, it answers my
question but the problem is that I have over 5000 tasks
to handle...

About the other issues (vba routine); only one resoure
works on each task but one resource may be assigned to
multiple tasks. I don't know what effects this may have.

The text that should be transfered is two text fields
(Text1 and Text3). One of these textfields contains a
project specification made up by a number and on some
occasions a letter (e.g. 23 or 2258APP). The second
textfield contains a description of the task/product
(e.g. APP-B or Converter box Z-std).

The text should be transfered between a task sheet view
(e.g. Gannt Chart with a custom-built table called Ny
post) and a resource view (e.g. Resource usage). The
field Text1 (task field) should thus be transfered to
Text1 (resource field).

Many thanks for any further information!

Best regards,
Anders Ekebergh