Keep detail data together when sorting
Posted by Patrick on January 31, 2001 9:14 AM
Is there any way to keep detail data rows with their respective summary rows when sorting. Hiding the rows doensn't work.
Posted by Mark W. on January 31, 2001 9:19 AM
Huh? Please explain in greater detail.
Posted by Mark W. on January 31, 2001 11:11 AM
Outlined?
Is your data outlined?
Posted by Patrick on January 31, 2001 11:23 AM
Yes, data is outlined
Summary rows may have variable number of detail rows (i.e. 2 or 3 rows of detail, some have no rows of detail data).
I need to sort the summary rows but keep the details with the summary rows.
The sheet is in outline format, but when I try to sort by the values in column A (which contains data in the summary row but is empty in the details row) the supposedly grouped data does not stay together.
Any ideas?
Posted by Mark W. on January 31, 2001 11:57 AM
Re: Yes, data is outlined
Are you collapsing the outline to show just the
summary rows before you attempt to sort?
Posted by Patrick on February 01, 2001 9:50 AM
Yes outline collapsed
Yes I am collapsing the outline to only show the summary rows. After sorting detail rows stay with each other but not with the correct summary row.
Posted by Mark W. on February 01, 2001 11:45 AM
That's odd!
I'm struggling to understand what could be wrong.
When I simulate your scenario it works fine for me!
Where do we go from here?
Posted by Patrick on February 01, 2001 2:08 PM
Thanks
Maybe the workbook is corrupted? Or worse the app is. I will probably re-install Excel 2000 and relaod my add-ins.
I figured something was wrong but haven't found any mention at MS sites on sort order for outlined data.
