Copy a Task Level Field to a Project Level Field

T

TroyS

Within PS2007
I want to be able to:
1) find a task where a task flag = Yes
2) Take the formula field from the task located above where the formula
resolves to a value (eg. Under Budget, Over Budget)
3) Save it to a project level text field to display in PWA Project Center

I have 2-3 sections of the project task template, where i allow people to
update time to a single time entry task, a section where i manage cost
resources and another section that is more of a full blown WBS which i
manage as %Complete. I can't use TaskID=0 as it would include essentially
duplicate effort between the time entry task and the detailed WBS.

Based on a Task that I flag I want to communicate that as my status of the
overall project in Project Center by setting a Project Level Field..
Because i may insert my detailed wbs or other cost tasks on any task id, i
need to be able to set a flag at the task to 'find' the task and copy the
results of the formula to the project level field so that i can ignore my
time entry task or my cost resource tasks....

as a newbie to vba, anyone have some ideas on how to tackle?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top