Managing WBS codes in MS Project w/ Macros
hi all,
i've got quite a complex problem on my hand here and i'm not getting any help here at work, so i hope someone out there can help me out. i'm gonna try to explain this in as much detail as i can, so i apologize if this is a little long, here it goes....
i'm using MS Project to keep track of the progress for a particular project that is ongoing here at my company. So, if you're familiar with MS Project, you'll understand that i've categorized all the tasks that are required for this project into levels and sub-levels using WBS codes (ie: 1.1, 1.1.1, 1.1.2, 1.2, 1.3, 2.1, etc..). So basically, i've got Task 1 and it is broken down into Task 1.1 and Task 1.2 and Task 2 is broken down into Task 2.1, 2.2 and 2.3, also Task 2.2 is broken down into 2.2.1, 2.2.2 and 2.2.3, etc...
ok, now that i've explained my situation, let me explain my problem...
So, i've created a bunch of custom fields (level1, lv 2, lv3, etc...) for each task and i only put INTEGERS in those customs fields. Also, I've created as many levels of custom fields as needed for each project. So, if my lowest level is 4 (ie: 1.2.3.1 or 3.4.2.1 or 2.5.7.1), then i've got 4 custom fields. Now, my problem is:
with all the different levels of custom fields, i've got to somehow find a way to design a macro that would ignore all the empty custom fields, but add up all the numbers from one level and place the sum onto the level above. Example: task 1.2.1 = 10 and task 1.2.2 = 3 and task 1.2.3 = 3, then task 1.2 should = 16.
Also, if 1.1 = 30, 1.2 = 16 and 1.3 = 24, then Task 1 should = 70.
So, hopefully, you didn't get lost... but that's the kind of macro that i need to design. Now, i might not be asking specifically for the exact VBA code, but i would greatly appreciate that... even any help with pseudocode will be great. if you can help, but don't understand all the details, just reply and let me know... thanks in advance to all
