If you really only have 2 columns: PartNum and Qty...you might want to
try this:

Assuming PartNum and Qty are in columns A and B, respectively, with
their data below:

D1: PartNum
E1: Qty

Select D1:E1
DataConsolidate
Reference: Select A1:B?? (as far down as your data extends)
Click [Add]
Click 'Use labels in Top Row'
Click 'Use labels in Left Column'
Click [OK]

The result will be the consolidation you are looking for.
If you like, you could clear your original data then copy/paste the
consolidated data in its place.

Another option would be to use a pivot table.
The pivot table would let you see the totals and the count of separate
orders for each part number.

Are either of those something you could work with?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=483478