How do you sort Grouped Data in 2003?

Hello Everyone,

I have just run in to this problem myself. I have a few groups or "Layers" as I like to call them of information. I have a master header which explains the level 1 information and then another header which explains level 2 information. What I am trying to do is to sort by the Level 1 headers and keep all the information underneath it linked to that header. That way I could pull the grouped row out and put it somewhere else and the information it had below it will stick with it. This isn't working for me in Excel 2003, I have read some replies and tried doing it the Subtotals way but that is no good. I am up for any suggestions!

Thank you,
Blake

EDIT: Please find a link to the discussion on the same topic http://www.excelforum.com/excel-gene...-in-excel.html