| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database summary
I have a workbook with 2 spreadsheets. In the first one, I have a column of
products that has a corresponding customer and the customer may appear more than once. I want to query that sheet and in the second sheet, have the customer list with the sum of quantity of products that customer purchased. All products are equivalent in size just different genetics. I just want to know how many each customer purchased. Sheet 1 customer1 product1 qty customer2 product1 qty customer2 product2 qty customer2 product3 qty customer3 product1 qty customer3 product2 qty customer4 product1 qty customer4 product2 qty Sheet 2 customer1 sum customer2 sum customer3 sum cusomter4 sum |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Threaded Mode
