I have several Excel worksheets that consist of three columns description, part number, and quantity. I want to combine them all into one worksheet so that quantity's get added together for rows with the same part numbers (bad description probably).

Can anyone tell me how to do it ? Compare and merge workbooks will not work because they are not the same worksheet (unless I am doing it wrong)

Can you place them as worksheets in the same workbook?

They are all in one workbook now.

VLOOKUP should do it.

Are the rows in each sheet unique? i.e. each part number only appears once in each sheet?

Lookup a part number from one sheet in the other and copy over the quantity. Add with others and done.

Not perfect, but might be enough for you.

Does response 3 here help?

http://www.computing.net/answers/office/summary-sheet-of-subtotals-from-mult-sheets/10074.html

Does consolidate do this? (never used it, just noticed it)

One of the guys in my office (different group) uses Pivot Tables for exactly this sort of thing. In 2007 you create the pivot table and then just drag the data from a list on the side to it and it adds the quantites based on part number automatically (and pretty damn quickly).

Sorry I can't be more help than that, but yesterday was the first time I even saw a Pivot Table.

Pivot Tables are nature's way of telling you that you should have used a relational database in the first place.

Peter