Sort question involving groups

M

Mike Connolly

Hi All,

I have a worksheet where I have used the group buttons to hide details in
the rows under a summary row. When I sort on columns, the detail rows get
lost in the sort. In other words the detail rows are no longer below the
correct summary row. Is there away to keep the rows together?

thanks,
Mike
 
N

NC

Dear Mike

The details row are needed to be hidden with help group button so that
after sorting(as the "groups" will be sorted & not the detail records)
they will move along with their summary row.

Regards
NC
 
M

Mike Connolly

Hi,

Excuse me, I'm kind of a novice. I didn't get what you mean by "hidden
with help group button".
I did hide the detailed rows using Format>Row>Hide. But, didn't help. The
detailed rows are still getting mixed up in the sort.

Thanks,
Mike
 
N

NC

well mike

by word "hide" i just mean collapse the rows so that only summary rows
would be visible with a + sign on the left of worksheet. (data>group &
outline>hide details)

i do not mean hiding then by Format>Row>Hide.
i hope this clarifies

Regards
NC
 
Top