Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need ONLY subtotals copied to a second sheet
I have a table of sales data similar to:
Category Item store1sales store2sales etc. baking mixes Item a 1 3 baking mixes Item b 3 4 baking supplies Item c 2 5 baking supplies Item d 5 6 etc. This is a table of 500 rows, with a variable number of categories and items each week. I need a subtotal of sales by like category for each store listed. So what I wind up with would look like: Category Item store1sales store2sales etc. baking mixes 4 7 baking supplies 7 11 etc. Total 11 18 These subtotals need to be on a second sheet, as I want the original (the detail) sheet intact for review. So 2nd sheet would have just categories listed with subtotals. As always, any help would be greatly appreciated! Denny Behnfeldt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copied from web page to excel sheet and cant remove from sheet | Excel Worksheet Functions | |||
copied from web page to excel sheet and cant remove from sheet | Excel Worksheet Functions | |||
When a sheet is copied, i want also that the Sub's whithin this sheet is copied to the new sheet | Excel Programming | |||
copied formulas refer to destination sheet not source sheet | Excel Worksheet Functions | |||
copied subtotals only | New Users to Excel |