setting multiple task durations using a parameter

[CK]

Is there a way to set the duration on multiple tasks using a parameter?

For instance, I have 30 shipping tasks (one for each different type of item)
and I believe that the shipping will be 3 days for each item. After a review
with the project team we might shift that to 5 days. Is there a way to set a
parameter to use as the shipping duration for all shipping tasks? If I could
only use a formula like in Excel I'd be set!

 

[Jim Aksel]

Formulas will only work on the custom fields not the normal duration field
for the task. So you would need a Visual Basic solution to "divine" the
shipping duration and plug that into the duration field.

For example, if shipping duration is a function of item weight, you could
put the Weight in a custom number field and then have a VBA macro that would
change the duration as a function of weight.

Perhaps an easier way would be to highlight all the tasks that are to have
the same duration and change that duration from the Task Information dialog
box on the standar toolbar.

--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

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