For simplicity's sake, I will be using basic titles and information for an excel workbook, i.e. Sheet1, Sheet2.
Background information for the sheets: Columns A will contain parts numbers on both sheets. Sheet2 contains all parts numbers possible for the given assembly. Sheet1 displays the part...