Sort 2 ranges with same Key
 

Is it possible to sort 2 seperate ranges by one key? If I had range
A1:C10 and it coincided with G1:G10; Is there a way to sort by B1 to
sort all of the columns in the ranges accordingly?

Thanks,
Jay

Sort 2 ranges with same Key
 

What about the data in D1:F10?

You can select A1:G10 and sort on B
then select D1:F10 and sort in the order you want... You might insert a
helper column and fill it with 1,2,3... to get the original order back.

"jlclyde" wrote:

Is it possible to sort 2 seperate ranges by one key? If I had range
A1:C10 and it coincided with G1:G10; Is there a way to sort by B1 to
sort all of the columns in the ranges accordingly?

Thanks,
Jay

Sort 2 ranges with same Key
 

On Nov 4, 1:01*pm, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) &
"hotmail.com" wrote:
What about the data in D1:F10?

You can select A1:G10 and sort on B
then select D1:F10 and sort in the order you want... You might insert a
helper column and fill it with 1,2,3... to get the original order back.



"jlclyde" wrote:
Is it possible to sort 2 seperate ranges by one key? *If I had range
A1:C10 and it coincided with G1:G10; Is there a way to sort by B1 to
sort all of the columns in the ranges accordingly?

Thanks,
Jay- Hide quoted text -

- Show quoted text -

B is the key column that I want to sort A:C and G. I want to leave
D:F alone. Is this possible?
Thanks,
Jay

Sort 2 ranges with same Key
 

No, you can not sort on multiple ranges...

What I had suggested is a work around.

"jlclyde" wrote:

On Nov 4, 1:01 pm, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) &
"hotmail.com" wrote:
What about the data in D1:F10?

You can select A1:G10 and sort on B
then select D1:F10 and sort in the order you want... You might insert a
helper column and fill it with 1,2,3... to get the original order back.



"jlclyde" wrote:
Is it possible to sort 2 seperate ranges by one key? If I had range
A1:C10 and it coincided with G1:G10; Is there a way to sort by B1 to
sort all of the columns in the ranges accordingly?

Thanks,
Jay- Hide quoted text -

- Show quoted text -

B is the key column that I want to sort A:C and G. I want to leave
D:F alone. Is this possible?
Thanks,
Jay