How can I create a BOM chart using VBA?

[Dava Masco]

Hi expert, I have a data table with 3 columns. Column 1: Type of product(Part or Unit). Column 2: Location . Column 3: Block. as image below:

Column 1: Defind name: Part /Unit
Column 2: Location to located part/unit in sheets
Column 3: The block column will show which items are assembled together, for example, 1.1, 1.2, and 1.3 will be assembled together into block 1. And 1.1 and 1.2 are parts, while 1.3 is a unit.
To easier imagine I will attach my expectation.

Can someone help me with this? I would greatly appreciate your assistance.

 

[saboh12617]

Hello,
I would recommend taking a look at SmartArt objects > hierarchy/process kinds. Those objects allow for easy "node insertion" during tree construction. However, this will require strong bases in VBA and good understanding of tree data structure. It's really not an "easy task".
Especially since you will need to "create the tree" as it appears you do not have a hierarchy structure yet, besides the "rows order". I would have used block numbers like so to make the task easier:

Product	Block
QC1	1.1
QC2	1.2
Unit1	1

 

[Dava Masco]

Hello,
I would recommend taking a look at SmartArt objects > hierarchy/process kinds. Those objects allow for easy "node insertion" during tree construction. However, this will require strong bases in VBA and good understanding of tree data structure. It's really not an "easy task".
Especially since you will need to "create the tree" as it appears you do not have a hierarchy structure yet, besides the "rows order". I would have used block numbers like so to make the task easier:

Product	Block
QC1	1.1
QC2	1.2
Unit1	1

Thanks you for your respond! First I also use SmartArt object but it's not reach my expectation. You can see image above. Can you give me or recommend for me SmartArt similar with my expectation?

 

[saboh12617]

I would go for the ones in Hierarchy. Maybe have a look a the Office.com ones too.