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.
Part | Laser | Saw | Bend | Paint |
---|---|---|---|---|
xx-xxx0 | x | x | ||
xx-xxx1 | x | x | ||
xx-xxx2 | x | x | ||
xx-xxx3 | x | |||
xx-xxx4 | x | x |
An example of what I what I would like to output to sheet two would be:
Part | Laser | Saw | Bend | Paint |
---|---|---|---|---|
xx-xxx0 | x | x | ||
xx-xxx1 | x | x | ||
xx-xxx4 | x | x |
Is there anyway to perform this task either within SW or Excel?
Try in Design Table (or in Excel) at the "Menu bar" click on "Data/Filter/AutoFilter"
Than click at the arrow to sort by..
Any other suggest..