multi level bom explosions in excel using vba

Подписаться 5 тыс.

Просмотров 11 тыс.

50% 1

In today's video I will share an Excel file that you can use to fully explode a bill of material (BOM) no matter how many levels exist. Using a simple VBA code and some clever array functions you can build this file and start exploding your items into components.
The file is available on my Patreon page:
/ excelhighway
------------------------------
Track: Travel With Us - Vendredi [Audio Library Release]
Music provided by Audio Library Plus
Watch: • Travel With Us - Vendr...
Free Download / Stream: alplus.io/travel-us

Наука

Опубликовано:

2 апр 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 9

@excelhighway3549 Год назад

The file is available on my Patreon page: www.patreon.com/ExcelHighway

@mohammadalshaboul9569 14 дней назад

Incredible work thank you so much. This basically solves my problem with the last video I believe I watched on your channel on the same topic.

@excelhighway3549 14 дней назад

Glad it helped!

@joshcosgrove832 Год назад

In your example there is a single item in level 2, 3, etc. Would it still work correctly if there were multiple sub assemblies from level 2 and on?

@excelhighway3549 Год назад

Yes, it is setup up to 5 levels.

@mohammadalshaboul9569 6 месяцев назад

@@excelhighway3549 I have the same question and I still don't understand how it works. its not levels exactly. it is that level one has 3 sub-assemblies in it (A, B, and C) and Sub-assembly A has 2 sub-sub-assemblies (lets say C and D). This is an example of 3 layers but 5 sub and sub-sub assemblies.

@excelhighway3549 6 месяцев назад

@@mohammadalshaboul9569 your example is 3 layers. First layer is the final item (layer 1). It's assembled from A,B,C (layer 2). A is assembled from C,D (layer 3). FG - A - C.