I am trying to simplify the process for identifying 'like' items used on
different MODELS of the same Basic PRODUCT. For example say: O-ring #12345 -
is used on SUPER VAC I(1ea) - and used on SUPER VAC II(3ea) - and used on
SUPER VAC III(4ea). I am starting with a different spreadsheet for each
MODEL# that include comumns for PART NUMBER, DESCRIPTION, COST and QUANTITY,
and what I am looking to create is a single spreadsheet for each BASIC
ASSEMBLY (SUPER VACS) with all the part numbers listed. Since the
description and cost of each part would stay the same, how can I consolidate
the data into one spreadsheet per Assembly, sorted by Part Number,
consolidating the duplicate part #'s into one row each that not only includes
'description' and 'cost', but also includes a column for each 'where used'
'and 'quantity'? I am using Microsoft Excell 2000.