AnsweredAssumed Answered

Excel: Master Parts Lists & Derived Parts Lists

Question asked by Dean Baragar on Feb 2, 2011
Latest reply on Feb 2, 2011 by Dean Baragar

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.

 

 

PartLaserSawBendPaint
xx-xxx0
x
x

xx-xxx1


x
x
xx-xxx2xx
xx-xxx3x
xx-xxx4xx

 

 

An example of what I what I would like to output to sheet two would be:

 

 

PartLaserSawBendPaint
xx-xxx0
x
x
xx-xxx1xx
xx-xxx4xx

 

 

Is there anyway to perform this task either within SW or Excel?

Outcomes