Hi, hope i can explain this in a reasonable way.

I have a worksheet with lots of product orders along with the
quantities of each part in each order.

Each part is duplicated many times, so an example would be this

Product Quantity
CD 11016 3
CD 11017 10
DVD 11006 0
CD 11016 2
VCD 11043 11
MP3 11052 12
DVD 11006 4
DVD 11008 6
DVD 11008 2
CD 11016 13

I need to create a new sheet which looks up each individual item, and
then next to that tells me the total quantity of that item that was
ordered. I'm sure there's an easy way to do this but can't for the life
of me think how to do it

Any help greatly appreciated!


--
andymaw11
------------------------------------------------------------------------
andymaw11's Profile: http://www.excelforum.com/member.php...o&userid=35931
View this thread: http://www.excelforum.com/showthread...hreadid=557243