| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insertm line and subtotal on separate worksheet
I am trying to create a workshete from another. I also need to insert a
subtotal line when the condition changes. For example, this is what the input spreadsheet looks like. AAA 20 AAA 30 AAA 40 BBB 20 BBB 35 BBB 15 BBB 25 CCC 25 CCC 25 CCC 25 This is what I am trying to make the output worksheet look like. AAA 20 AAA 30 AAA 40 Subtotal AAA 90 BBB 20 BBB 35 BBB 15 BBB 25 Subtotal BBB 95 CCC 25 CCC 25 CCC 25 Subtotal CCC 75 Total 260 I need to avoid manual interventon and I have to be able to automatically break on the change and insert a subtotal row. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insertm line and subtotal on separate worksheet
Hi,
I prefer pivot tables but your problem can be solved easily with the Data, Subtotal command. (2003) or the Data, Subtotal command in 2007. If this helps, please click the Yes button Cheers, Shane Devenshire "Smitty" wrote: I am trying to create a workshete from another. I also need to insert a subtotal line when the condition changes. For example, this is what the input spreadsheet looks like. AAA 20 AAA 30 AAA 40 BBB 20 BBB 35 BBB 15 BBB 25 CCC 25 CCC 25 CCC 25 This is what I am trying to make the output worksheet look like. AAA 20 AAA 30 AAA 40 Subtotal AAA 90 BBB 20 BBB 35 BBB 15 BBB 25 Subtotal BBB 95 CCC 25 CCC 25 CCC 25 Subtotal CCC 75 Total 260 I need to avoid manual interventon and I have to be able to automatically break on the change and insert a subtotal row. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bold & add line after subtotal row | Excel Worksheet Functions | |||
| would like each subtotal line highlighted | Excel Discussion (Misc queries) | |||
| To separate two line in a line chart | Charts and Charting in Excel | |||
| How do you add a blank line automatically after the Subtotal line | Excel Worksheet Functions | |||
| Subtotal line selection | Excel Discussion (Misc queries) | |||
Linear Mode
