Hi

it's hard to answer this without knowing what your worksheet looks like, if
it looks like this:
..........A..............B
1....School1......Business1
2....School1......Business3
3...School2......Business1
4....School1....Business2

and you want to see
..........A..............B
1....School1......Business1
2....School1......Business3
3....School1....Business2
4...School2......Business1

then click in A1 and choose data / sort and ensure only the first drop down
box has school in it and the other 2 drop down boxes have nothing in them.

However, if you have
..........A..............B
1....School1......Business1
2......................Business3
3...School2......Business1
4....School1....Business2

and you want to see
..........A..............B
1....School1......Business1
2......................Business3
3......................Business2
4...School2......Business1

then i have no idea on how to do this

Cheers
JulieD

"magnetoworld" wrote in message
...
I have schools that are linked to three different businesses. I am trying
to
sort the schools by their name, but when I do, it sorts the businesses by
their names as well. How can I make the schools sort and simply pull the
businesses that are under them with them? I need to group them in such a
way
that it sees the school and moves the entire block with the school name
without moving any of the businesses. Can anyone help me with that?