Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated report
I have posted this request before but I have only gotten responses that
require manual intervention. I need to be able to open the worksheet and have it automatically populated. The Data, Subtotal commands won't work for what I need to do. I think I need a macro to do what I want to do. I am trying to create a worksheet from the contents of 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 need the new output worksheet to 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Automated Footer | Excel Discussion (Misc queries) | |||
Automated Linking | Excel Discussion (Misc queries) | |||
Header in Report Manager Report | Excel Discussion (Misc queries) |