My BOM in SW outputs some custom properties which provide me with information such as whether the part is bent, saw cut, laser cut, ect. (see table below).
I am able to save my SW BOM as an excel file which is really nice as I can get a full BOM. From here I would like to add a bit of functionality by adding several worksheets to the excel file and pull certain information from my master parts lists to these worksheets so that I could obtain a saw list, laser list, ect.
An example of what I what I would like to output to sheet two would be:
Is there anyway to perform this task either within SW or Excel?