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.
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.