Additional note may be causing the problem?
In my Sheet1 there happens to be more than one row with the same PARTID,
however in Sheet2 the PARTID is only listed once.
In my sheet1 they are listed more than once because I could not get the rows
combined. In other words,

(Sheet1)
A B C D E
F
PARTID Description COrderCount CO Qty AvgPrice
WOrderCount
ROW1(abc) (collet) (1) (1) (750.00)
(blank)
ROW2(abc) (collet) (blank) (blank) (blank)
(1)

Sheet2
A B C D
E
PARTID QuoteCount PartQty AvgUnitPrice AvgTotalPrice
ROW1(abc) (1) (1) (750.00) (750.00)
ROW2(def) (1) (6) (1.60) ( 9.60)
Am I going to have to figure out how to get the Sheet1 down to one row per
partid for this to work?