I am hoping some can help me with code to create a group/outline structure to show the different levels (parent/child relationship) on a Bill of Material. I am able to do this manually, but it is rather time consuming when there are 1000's of items in the Bill of Material. The list I am working with contains the item and the level of that item within the Bill. A particular item may be at different levels throughout the Bill. My goal would be to have the list like the image below where if you select the #1 outline button you will only see level 1 items, selecting the #2 outline button will show all level 1's and level 2's and so on, up to 7 levels. Any help would be greatly appreciated. Note: I had hoped to include a screen snapshot of the end result I am looking for, but I haven't yet figured out how or if I can do that on this forum.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VB to create a Bill of Material group/outline
- Thread starter danptwash
- Start date
