View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default Sorting with Groups

Hi
Not sure what your layout is, but I suspect it is something like

Group1
Name1 ID1
Name2 ID2
Group2
Name3 ID3
Name4 ID4
Name5 ID5

etc
If so, change the layout to include a group column
Name1 ID1 Group1
Name2 ID2 Group1
Name3 ID3 Group2 etc

Is that what you mean??
regards
Paul

Dan wrote:
Is it possible to maintain cells grouped togther (using the Data-Group and
Outline-Group) when using Autofilter?

I have columns A-T with varying lenghts of rows grouped together. I want to
be able to filter on specific information in a column (using autofilter) but
maintain the group to see what is tied to that particular item.

Any ideas?

Thanks