Sorting a spreadsheet that is grouped/outlined


R

RC

Hello, I have data that is in a WBS (work breakdown structure) format.

A
AA
AAAB
AAAC
AB
B
BA
BB
BBA
....

Each WBS has a cost associated with it. I'm struggling with a good VBA
way to determine the cost drivers of the costs that are associate to
each WBS item and put them in order from largest cost driver on
downwards. So for example.

A - $1000
AA - $750
AAAB - $500
AAAC - $250
AB - $250
B - 500
BA - $100
BB - $400
BBA - $100
BBB - $300
C
....

I would need my macro to be able to output something like the
following, and then be able to create bar charts where I can show the
Level 1 cost drivers, level 2 cost drivers, etc (Level 1 being A,
Level 2 being AB, etc.)
A - $1000
AB - $750
AA - $250
AAAC - $200
AAAB - $50
B - $500
BB - $400
BBB - $300
BBA - $100
BA - $100

Any advice? You suggestions are greatly appreciated.
 
Ad

Advertisements

P

Patrick Molloy

i don't get why AB is a higher level than AA or why BB is higher than BA.

try adding a column for levels
maybe you need to add a custom list.

I'm not clear on what you need from there - maybe just add a bar chart?
 
Ad

Advertisements

R

RC

Hi, sorry to confuse. In the 2nd part of my example, AB is a higher
livel than AA and BB is higher than BA because the costs associated
with those line items are higher. I'm looking to order the WBS line
items in the order of the highest to lowest cost.

The ultimate goals is to see the biggest costs for a program, by WBS
line item, by level. Maybe this is clearer?
Level 1 Cost Drivers
A
B
Level 2 Cost Drivers
AB
AA
BB
BA
Level 3 Cost Drivers
AAC
AAB
BBB
BBA
 

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