I am trying to get data to sort so that when I sort by a column, it
actually moves all the data in the row along with it as though that
data was anchored to it.

Example

Tom 3 D 66 JH L
Bob 4 F 56 GH N

If I sort by column D I want all of Bob's information to move on top so
it looks like:

Bob 4 F 56 GH N
Tom 3 D 66 JH L

I can only get it to sort the column, but then I've basically assigned
the wrong values (example):

Tom 3 D 56 JH L
Bob 4 F 66 GH N

Is there anyway to do this?


--
RPIJG
------------------------------------------------------------------------
RPIJG's Profile: http://www.excelforum.com/member.php...fo&userid=9285
View this thread: http://www.excelforum.com/showthread...hreadid=397324