Expand and collapse

F

Fawn Lagimodiere

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
 
I

isabelle

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
Click to expand...
long time since there are over 2000 rows.
 
I

isabelle

oops sorry i misreading,
why not use a filter?

isabelle

Le 2014-05-29 10:47, isabelle a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Expand Collapse not showing for Cube 2
Expand and Collapse groups 1
Expand/Collapse in Pivot Tables 2
Excel pivot tables - specific expand/collapse buttons visibility 1
Expand and Collapse rows using a macro 16
Pivot Table Question 2
Outline, expand or collapse via VBA 1
collapse an expand rows using VB 7

Top