If you wanted to avoid macro, I would paste both lots of data onto the
same sheet in the same columns. If U then create a new column called
product and copy the product description next to the parts it relates
to.
you can then run a pivot table, select all the data
Choose PART NUMBER, DESCRIPTION, COST as row headings,
product as column headings
Quantity as data (it should default to sum which is fine)
A new table will be created, if you then click on any of the totals
they will be highlighted and can be deleted
If you select the whole table then copy it as values elsewhere, you
have a table that can be updated an dis not dependent upon data
I hope this is clearish, if not please get back in touch
Have fun
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=507086