roll up

[ellebelle]

I would like to pull the rollup data (entered manually) from a custom text
field into all the subtasks of the same text field. However if this is
impossible then it could be pulled to another text field. Any help much
appreciated

 

[Rob Schneider]

If I understand you correctly, it's possible; but to automate you would
need to do it with VBA. The algorithm to do so would probably be just
like you would do it if you did it manually. Basically you would let
Project compute the rolled up value, get that value, then identify all
subordinate tasks for that summary tasks, and then update each task's
target custom field that is to hold that data with the new data.

--rms

www.rmschneider.com

 

[Jim Aksel]

I am not so sure I understand the question. Do you want to place the value
contained in a custom text field (say Text1) that is on a summary level and
you want to have that value also appear in the Text1 field of all the
subtasks that roll up to that same summary task? How about fill down or just
copy/paste?

You can also do it with a macro and VBA. You would examine the children of
a task and then populate the field that way. This may get tricky becuase
there can be children, grand children, great grandchildren... etc. You would
work your code in combination with the outline level or perhaps recursively.

Is that what you meant?
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

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