link data to other data
 

Im trying to sort in accending order colum B and i need the names in colum A
to sort also.

link data to other data
 

One way is to Highlight all data you want sorted in both columns. Click
on Data then Sort. Set the sort order to Column B and select if you
have a header or not and tell it to sort. This should do what you
want.

Hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=511274

link data to other data
 

Yes that worked well,
But I need to keep the original data in its original order and on another
sheet i need the same data in the sorted state. Any thoughts?

"goober" wrote:


One way is to Highlight all data you want sorted in both columns. Click
on Data then Sort. Set the sort order to Column B and select if you
have a header or not and tell it to sort. This should do what you
want.

Hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=511274

link data to other data
 

Ashley

Right-click the sheet tab Click 'Move or Copy'.
Put a checkmark in 'Create a copy', click OK.

You now have 2 identical sheets.
Sort one of them, leave the other unsorted!

Hope this helps.

George Gee


"Ashley" wrote in message
...
Yes that worked well,
But I need to keep the original data in its original order and on another
sheet i need the same data in the sorted state. Any thoughts?

"goober" wrote:


One way is to Highlight all data you want sorted in both columns. Click
on Data then Sort. Set the sort order to Column B and select if you
have a header or not and tell it to sort. This should do what you
want.

Hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile:
http://www.excelforum.com/member.php...o&userid=19838
View this thread:
http://www.excelforum.com/showthread...hreadid=511274