jbesclapez
Active Member
- Joined
- Feb 6, 2010
- Messages
- 275
Hi Mr Excel
I have a table that can change in rows/columns. In this table I only have one data per row. The columns indicate the hierarchy of parent child structure. The parent is on the left.
For example :
<tbody>
</tbody>
So from the previous table we have this hierarchy. Please note that the A1000 is the root so it has no parent
<tbody>
</tbody>
I would like to have a VBA where you select the table above - whatever the depth level - and it creates the parent child table elsewhere.
I can read VBA but this level is too high for me. I will rearrange it all for my needs if you can help me create the difficult part.
Thanks
I have a table that can change in rows/columns. In this table I only have one data per row. The columns indicate the hierarchy of parent child structure. The parent is on the left.
For example :
Level1 | Level2 | Level3 |
A1218 | ||
A1219 | ||
A1220 | ||
A1200 | ||
A1110 | ||
A1111 | ||
A1100 | ||
A1000 |
<tbody>
</tbody>
So from the previous table we have this hierarchy. Please note that the A1000 is the root so it has no parent
Parent | Child |
A1200 | A1218 |
A1200 | A1219 |
A1200 | A1220 |
A1000 | A1200 |
A1100 | A1110 |
A1100 | A1111 |
A1000 | A1100 |
A1000 |
<tbody>
</tbody>
I would like to have a VBA where you select the table above - whatever the depth level - and it creates the parent child table elsewhere.
I can read VBA but this level is too high for me. I will rearrange it all for my needs if you can help me create the difficult part.
Thanks