Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand and collapse
I have a file that uses data from external sources. I currently have it running on pivot table. The rows will always change from month to month so using grouping would take a long time since there are over 2000 rows.
With pivot table reports there is a function to expand and collapse fields. Is there a way to use a similar function without a pivot table? Thanks Fawn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand and collapse
hi,
you can define a named range dynamic "MyQuery" as follows : =OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A),COUNTA( Sheet1!$1:$1)) isabelle Le 2014-05-29 00:50, Fawn Lagimodiere a écrit : I have a file that uses data from external sources. I currently have it running on pivot table. The rows will always change from month to month so using grouping would take a long time since there are over 2000 rows. With pivot table reports there is a function to expand and collapse fields. Is there a way to use a similar function without a pivot table? Thanks Fawn |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand and collapse
oops sorry i misreading,
why not use a filter? isabelle Le 2014-05-29 10:47, isabelle a écrit : hi, you can define a named range dynamic "MyQuery" as follows : =OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A),COUNTA( Sheet1!$1:$1)) isabelle Le 2014-05-29 00:50, Fawn Lagimodiere a écrit : I have a file that uses data from external sources. I currently have it running on pivot table. The rows will always change from month to month so using grouping would take a long time since there are over 2000 rows. With pivot table reports there is a function to expand and collapse fields. Is there a way to use a similar function without a pivot table? Thanks Fawn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
expand or collapse | Excel Programming | |||
how do i expand and collapse rows | New Users to Excel | |||
Expand Collapse Buttons | Excel Discussion (Misc queries) | |||
Expand/collapse | Excel Programming | |||
expand/collapse row button | Excel Discussion (Misc queries) |