Create WBS numbers with a macro

[datadrvn]

Hi…rookie VBA-er here on Excel 2007. I export data out of a tool called PlanView and am trying to lightly mimic what MS Project does innately. I found some posts related to this but the starting points for those are usually exporting from MSP to Excel, which already had the WBS levels defined. I’m coming from the other direction, exporting from a tool that has no “leveling” and trying to mimic the WBS number creation process MSP handles natively.

1. I have a list of tasks that are subordinate to one another (Phase, Deliverable, and Activity).
2. Currently column A contains an outline level corresponding to the task, i.e., Phase = level 1, Deliverable = level 2, and Activity = level 3. I used the presence of "Pha", "Del", and "Act" in the task description (LEFT) to determine these levels.
3. I’d like to modify it I can get a single value for an outline level that tiers the levels into a x.x.x format, e.g., 1.1.2 would be the first phase, first deliverable in that phase, and 2nd activity within that first deliverable.
4. The list will grow / shrink over time so the number of phases, deliverables, and activities will change. However, the task descriptions will always begin with those text values, e.g., phases always begin with “Phase.”

Help?

p.s. sure wish I knew how everyone inserts an excel table in their posts...