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

You need to highlight (Select) the entire range you want to sort (A1:G2
in your example), then click DataSort from the main menu to call up
the Sort dialog box. Select your desired column to use for the sort
(Column D in your example), pick Ascending or Descending, and click
either Header row or No header row. Click OK to do the sort.

TIP: always SAVE your data BEFORE you do a sort, just in case the
results are NOT what you planned!

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=397324