G

#### Guest

materials and quantities. The first column contains a Part Number, the second

column is a Part Number Name, and the third column is Quantity. Part Numbers

(and their associated names) repeat through out this listing.

I need to query the worksheet to determine what the total quantity of each

Part Number is, and on a second worksheet display in 3 columns; Part Number;

Part Number Name; and Total Quantity (where Total Quantity equally the sum of

all the same Part Number quantities). On the second worksheet only one

instance of each Part Number & Part Number Name should appear.

Any help would be appreciated.

Thanks