Populate Task Textfieled 2 from resource text field 2

[Magnus S]

What is the best way of populating Task text field 2 from Resource Text field
2

I have tried understanding the formula with no succes seems that you only
can reference text fields and.....

Should I use VBA any advice welcome...

 

[Jan De Messemaeker]

Hi Magnus,

First, you are aware that this only makes sense if there isn't more than one
resource on a task?
You can indeed do this via VBA:

Sub Text2_To_Task
dim lousyjob as task
for each lousyjob in activeproject.tasks
if not lousyjob is nothing then
if lousyjob.assignments.count>0 then
lousyjob.text2=lousyjob.resources(1).text2
end if 'assignments
end if 'is nothing
next lousyjob
end sub

HTH

 

[Lars Hammarberg]

Are you trying to copy the data in assignment text field 2 to task text
field 2 so that the same values appear in all fields in a task usage view,
for instance?

/Lars Hammarberg
www.camako.se
MSProject Premier Partner

 

[Magnus S]

Problem: How use external resources with there own calendars but internally
responsible people

We would like to see who internally is reponsible for all tasks.....
The internally resp. will be in field Task.Text5

E,g if external body B is doing a work then we will have MrX as responsible

We have solved this as
Resourcename B
resource.text1 MRX

If it is an internally source doing the work we use what is in field
Resource name as
responsible internally ( field task.text5)