Sorting 2 columns of names with the same 2 columns& limited rows Closed

Question

Hello, 

I am looking for some help with an Excel Spreadsheet.

I have an Excel Spreadsheet with room for only 2 columns and 5 rows. 

I am trying to sort 8 names alphabetically in those 2 columns and 5 rows. 

For instance:

Column 1 has the names:
Jones  
Smith  
Barnes  
Archer 
Anderson 

Column 2 has the names:
Young
Lawson
Fox

I would love to be able to set sort them quickly into the following:

Column 1
Archer  
Anderson  
Barnes  
Fox 
Jones 

Column 2
Lawson
Smith
Young

It would even be better if I could set this up to be operated by 1 click.

Thank you so much in advance for any help you can offer.  I would greatly appreciate it!!

ac3mark · Answer

Tt is this simple:

Range("A1:A1").Sort key1:=Range("A1"), _      order1:=xlDescending, Header:=xlNo 
 
Or, highlight the column, and SORT!

Sorting 2 columns of names with the same 2 columns& limited rows

1 response

Subscribe To Our Newsletter!