Hi,

You could create a pivot table. Drag list to the row area and quantity to
the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Stevet" wrote in message
...
Hello, I'm using Excel 2003
Can anybody help me please, I have a worksheet that has a list of fabric
names (with some names duplicated and sometimes in different areas of the
list, ie; chenille, chenille, Pampas, Aster, Pampas, Chenille) and next to
it
is a list of quantities. What I want to do is on another work sheet work
out
how much chenille, Pampas and Aster without the need to write everything
down
more than once. so for instance a column with Chenille, Pampas and Aster,
and
the next column with the corresponding quantities all added up for me.

--
Kind regards,
Stevet