Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge /Join data
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge /Join data
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge /Join data
this helps a ton......but i canot figure how to get these 17 rows to 3 rows
based on product with summed qty....? AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 3 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 5 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD 1 CONCRETE TECHNOLOGY AutoCAD LT 1 CONCRETE TECHNOLOGY AutoCAD LT 13 CONCRETE TECHNOLOGY AutoCAD Mechanical 1 CONCRETE TECHNOLOGY "Michael" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
join rows? | New Users to Excel | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
join 2 spreadsheets | Excel Discussion (Misc queries) |