Maybe...

If you put a key value on each of the 3 rows in the group (add a column) and
then put an indicator (1, 2, 3) in another added column, you may be able to sort
by those two columns.

Be aware that if you have ties on this key column, you'll want to make each key
unique:

Another option (depending on how many columns each row is using) is to combine
your 3 rows of data into a single row. Then sort that -- and split the results
into 3 rows.

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

--

Dave Peterson