D
Dan
Is it possible to maintain cells grouped togther (using the Data->Group and
Outline->Group) when using Autofilter?
Here is what I have
C1 C2 C3 C4 C5 C6 .... C15
R1 apple 2 3
R2 ab ac gd .... r5
R3 ee et tg .... cb
R4 cf de ij .... ok
R5 pear 4 5
R6 ab ac gd .... r5
R7 ee et tg .... cb
R8 tree 3 6
R9 0d 34 4f .... gi
Now rows 2-4 are grouped, 6&7 and 9 so that they collapse under their header
in columns C1-C3. There is also a filter set up on C1, C2, C5 and C6. (Used
Autofilter, then hid the display of the arrors on C3 and C4). Each
entry in column C1 may have multiple entries with different data in C4 - C15.
Now when I use the autofilter to select "pear" I want to maintain the
grouping underneath to see the different information that has been entered.
Any ideas?
Outline->Group) when using Autofilter?
Here is what I have
C1 C2 C3 C4 C5 C6 .... C15
R1 apple 2 3
R2 ab ac gd .... r5
R3 ee et tg .... cb
R4 cf de ij .... ok
R5 pear 4 5
R6 ab ac gd .... r5
R7 ee et tg .... cb
R8 tree 3 6
R9 0d 34 4f .... gi
Now rows 2-4 are grouped, 6&7 and 9 so that they collapse under their header
in columns C1-C3. There is also a filter set up on C1, C2, C5 and C6. (Used
Autofilter, then hid the display of the arrors on C3 and C4). Each
entry in column C1 may have multiple entries with different data in C4 - C15.
Now when I use the autofilter to select "pear" I want to maintain the
grouping underneath to see the different information that has been entered.
Any ideas?