AnsweredAssumed Answered

Macro to split a BOM at each sub assembly

Question asked by Scott Giffin on Feb 23, 2018
Latest reply on Feb 26, 2018 by Scott Giffin

Is there a way to split a BOM at each sub assembly? What I have is about a 100 part assembly that consists of 5 punch side and 5 die side sub assemblies plus a set of cutoff tools. I have the separated tools listed how we want to see them on the sheet as general tables as an example. I would like to have a linked BOM in place of the general tables but it would need a lot of manual tweaking that I'd like to automate as much as possible. Starting with splitting it at each sub assembly. Then hide the sub assembly names to show only the tools. Hiding the headers would be nice too but not a priority at this point. I also need it to list each instance of the tools separately so they would show up in each station instead of as a quantity in the first station it's in. Essentially what I want is for every lines quantity to be 1. Then don't show the quantity column since it will no longer be needed. I have a good start on the macro based on an awesome video I watched from Amen of cadhero.com which I will attach here. So far it only does the cutoff tools. If there is a sheet 2, it will transfer the remaining tools to that sheet which then will require further splitting at a yet to be determined spot. Any help is greatly appreciated!

Attachments

Outcomes