Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing Rows with subtotals...
Hello All,
I have a macro that has run and created multiple subtotals. At the end, I would like the macro to collapse all of the subtotal ranges so that the user will see just the summary subtotal data. Does anyone have any ideas on how to accomplish this? Thanks, Trevor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing Rows with subtotals...
Turn on the macro recorder, then collapse the rows. Turn off the macro
recorder, and you should have your code. -- Regards, Tom Ogilvy "Jesterhoz" wrote in message ... Hello All, I have a macro that has run and created multiple subtotals. At the end, I would like the macro to collapse all of the subtotal ranges so that the user will see just the summary subtotal data. Does anyone have any ideas on how to accomplish this? Thanks, Trevor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing Rows with subtotals...
I have been following your threads and I have what might be a silly question.
Are you using the subtotal function or are you using Data - Subtotals. Data - subtotals is definitely the way to go... "Jesterhoz" wrote: Hello All, I have a macro that has run and created multiple subtotals. At the end, I would like the macro to collapse all of the subtotal ranges so that the user will see just the summary subtotal data. Does anyone have any ideas on how to accomplish this? Thanks, Trevor |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing Rows with subtotals...
I have been using Data - Subtotals for the main portion of the sheet. Then
Tom so wisely suggested that I use a "dummy" subtotal function within the cell formula for my percentages. I used that in order for the grand subtotal to ignore its value. I then was looking for a way to "roll up" the subtotals and I had forgotten about the little 1,2,3 buttons in the top left corner and was trying to record a macro by individually collapsing each subtotal range. All is good now, however. Thanks to all. "Jim Thomlinson" wrote: I have been following your threads and I have what might be a silly question. Are you using the subtotal function or are you using Data - Subtotals. Data - subtotals is definitely the way to go... "Jesterhoz" wrote: Hello All, I have a macro that has run and created multiple subtotals. At the end, I would like the macro to collapse all of the subtotal ranges so that the user will see just the summary subtotal data. Does anyone have any ideas on how to accomplish this? Thanks, Trevor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
collapsing rows together | Excel Worksheet Functions | |||
collapsing rows | Excel Worksheet Functions | |||
Collapsing Rows | Excel Discussion (Misc queries) | |||
Expanding and collapsing rows | Excel Discussion (Misc queries) | |||
Expanding/Collapsing Rows? | Excel Worksheet Functions |