I have just put up an EXCEL 2007 file for you at:-

http://www.pierrefondes.com/

Item number 84 (towards the top of the home page at the time of posting).

I think this gives you what you want.

If you agree please hit Yes.

Thanks.

"JJ" wrote:

Help please. I have two worksheets, A and B.

In A (BOM) I have the following info:
WORK ORDER CODE QTY
BLD096OF01 2-40-030B7 1.0
BLD555AA02 2-40-030B7 5.0

In B I require to extract the code and qty per Work order as this is
required for planning purposes.