View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
curtc. curtc. is offline
external usenet poster
 
Posts: 1
Default sorting columns at the same time but independently of each other

Is their a function or short macro that will sort columns by alpha but will
do all columns on the sheet at the same time and independently of the data in
the other columns?
Example:
A B C
1 fred john james
2 albert zack chris
3 bill curt mike

Updated:
A B C
1 albert curt chris
2 bill john james
3 fred zack mike