My next problem is I need to extract only certain information from a
worksheet as sample-

Worksheet A Worksheet B
Column A Column A Column B
Column C

SP001 SP001 PL001
16
SP001
PL002 1
SP001
DC001 5

Worksheet B is my Bill of Material but I only want to extract only certain
info such as PL001 / PL002 with the qty's.

Any assistance is appreciated.