Hi Kevin. Take a look at the Subtotal function on the Data menu. First,
sort your table, product, customer. Then use subtotals - for each change in
product sum qty. Then, don't replace those subtotals, but do it again based
on customer. HTH
--
Sincerely, Michael Colvin


"Kevin R" wrote:

i have a worksheet that has 17 rows with the following columns:
Customer, Product, Qty, and a few more....
In each of the 17 rows customer name is the same, but Product and Qty will
vary.
I would like create a macro or use some built in excel tool to Merege the 17
rows to 2 rows based on the Product Name and sum up the qty.

IN other words based on the Product column merge/join a selection set to a
single row for each customer, product, with QTY totaled?

any thoughts?