First excuse my english, it's not my first language...

My problem is that I have a sheet with thousands of lines like those (I
used "_" to align my column because space are not working) :

CLIENTS PRODUCT QTY TOTAL

Roger __ product1 __ 2 __ 080$
Roger __ product1 __ 3 __ 120$
Lynda __ product1 __ 1 __ 040$
Lynda __ product2 __ 1 __ 050$
Lynda __ product3 __ 1 __ 040$
Lynda __ product3 __ 2 __ 080$

and I need to add quantity and total for each time the client and the
product is the same to obtain something like this :

CLIENTS PRODUCT QTY TOTAL

Roger __ product1 __ 5 __ 200$
Lynda __ product1 __ 1 __ 040$
Lynda __ product2 __ 1 __ 050$
Lynda __ product3 __ 3 __ 120$


I didn't find a way yet to do that...and like I said I have thousands
of lines on my sheet so I have to find a way to do this with a
function, a macro or something like that. By the way I'm using excel
2002.

If someone can help me please,

Thanks


--
Pwel
------------------------------------------------------------------------
Pwel's Profile: http://www.excelforum.com/member.php...o&userid=26191
View this thread: http://www.excelforum.com/showthread...hreadid=395006