BOM template based on Indenture to ERP template

Hi WBD,

Wow. That worked amazing! One problem however, when I added a fourth indent to test it stopped working. As seen in the attachment it now also displays P3-A1001,
P3-A1002, P3-A1003, P3-A1004 and P3-A1006. It shouldn't do that, as these are not a BOM when it does not have components under it. Any idea how to fix that?

Utter perfection. Thank you so much!

It works perfect. I do have one more request if it isn't too much effort.
I would like Sheet 1 to be INSERT and Sheet 2 to be OUTCOME. I cannot figure out how to change the code to work with sheets.

There is an INSERT tab with the BOM, Quantity, Sort Codes etc., there is an INSTRUCTIONS tab (where I want to place the VBA Button for the code to run) and then there is the OUTCOME tab where I upload the data.

Yes both are perfect! Insert A2, Outcome A2

It is amazing how fast you can write this up damn! It works!

Test Reply

Hi WideBoyDixon,
As you helped me so gracefully last time, I wonder if you could help me with an additional issue. The macro you wrote worked beautifully, but unfortunately, the standard for BOM explosions (2 level indenture) is not followed by everyone and I more often than not receive a BOM with two different problems, or, (1) they use spaces instead of indents, and (2) they use 1 level indents, and not 2 level indents. I wonder if there is any easy solution for this, to identify what is happening, and then to convert it to 2 level indents so the rest of the BOM macro can still be used. Or do you advise to have separate buttons? (space to indents, indents 1 to indents 2, and then your previous macro as the third button). I found a macro for spaces to indents but it was very very slow, and you had to select, and than run it, very inefficient, and still not resolving the other issue. I hope you could help me out, thank you so much in advance for having a look.