If I've interpreted correctly, then if you highlight the areas you want to
attach and make them into a named range. Then use the dropdown at the top
left to select the named range then use data sort this should only sort
within the range selected



"excelBRISKbaby" wrote:

Hello,
I have a worksheet setup with mutliple rows that are dependent on one
another. I.e. Row 1 is the title, Row 2 is data about row 1, Row 3 is data
about the title in row1, this repeats for new title/data every three rows. I
would like to be able to sort data based on the title in row 1 /4/7/etc. and
have the other rows move with the title row. In other words I want to
"attach" row 2 and row 3 to row 1. Is there any way to do this?

I am using Excel 2003.

Thank you very much,

excelBRISKbaby