Sorting LISTs
 

Hi, I have a table with multiple lists. How do I sort one column and have the
rows moved with it? Selecting the entire sheet or the table greys out 'Sort'
under the Data menu.
For eg,
List1: Name, List2: Company they belong to, List3: State

How do I sort one column and have the entire row carried with it? If there
is an option to Sort by List1 first and then by List2 etc it will be great.
Is there a work around without having to unList the data?

Thanks in advance!

Sorting LISTs
 

Select all of the data within the Lists area, the sort is then valid for
it's usual 3 keys.


Tia Wrote:
Hi, I have a table with multiple lists. How do I sort one column and
have the
rows moved with it? Selecting the entire sheet or the table greys out
'Sort'
under the Data menu.
For eg,
List1: Name, List2: Company they belong to, List3: State

How do I sort one column and have the entire row carried with it? If
there
is an option to Sort by List1 first and then by List2 etc it will be
great.
Is there a work around without having to unList the data?

Thanks in advance!


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486406

Sorting LISTs
 

Thanks Bryan, but when i select the data within one of the Lists (selecting
data under multiple Lists greys out 'Sort'), it only sorts the data selected.
It does not move the entire row with it.

"Bryan Hessey" wrote:


Select all of the data within the Lists area, the sort is then valid for
it's usual 3 keys.


Tia Wrote:
Hi, I have a table with multiple lists. How do I sort one column and
have the
rows moved with it? Selecting the entire sheet or the table greys out
'Sort'
under the Data menu.
For eg,
List1: Name, List2: Company they belong to, List3: State

How do I sort one column and have the entire row carried with it? If
there
is an option to Sort by List1 first and then by List2 etc it will be
great.
Is there a work around without having to unList the data?

Thanks in advance!


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486406