MS-Project Table / Columns Cross Referencing

[metho_1981]

Hi folks,

Hopefully somebody has come across this issue before... We have been
setting up a new schedule using the MSP default Gantt chart (which
references the Task table I think) view. All the usual fields are filled
in - Task Name, Work, Duration, etc. We have also filled in a text
field, Text12, with some specific data.

What we would then like to do is be able to reference the data in
Text12 in other views where, for example, the Task Name is visible. For
example, the Resource Usage view... I assume this view uses the
Assignment table. By default, the Task Names do appear in the view,
listed under each resource heading. However, Text12 is blank. It appears
to be because Text12 in the Assignment table and Text12 in the Task
table are not the "same" Text12 field, which makes sense...

The question is, is there a way to copy the contents on Text12 in one
view/table across to Text12 on another view/table? -- Have tried to the
best of my knowlege and come up short, if anybody here has any
ideas/tips/suggestions they would be much appreciated...


Thanks,
Matt

 

[Jim Aksel]

Project has several places (table types) where data is stored: Assignment
Data, Resource Data, Task Data. Each of these has its own Text12 (and other
custom fields).

In order to reference Text12 in a Task Table type in a Resource Table Type
you need to do some Macro programming.

Read FAQ#57 and FAQ#37 here: http://project.mvps.org/faqs.htm
It talks about the subject and tells you how to do the code.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[metho_1981]

That's great Jim, thanks for your help. Exactly what I was after.


Cheers,
Mat

 

[Michael.Tarnowski]

Hi Jim,
there is no FAQ#57 in the stated URL http://project.mvps.org/faqs.htm
Cheers Michael

 

[Jan De Messemaeker]

It's 51 and 37.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf