multi column sort

[jasko]

Multiple columns full of numbers needs to be sorted from lowest to highest each column separately. The only way I know is to do each column separately.
Appreciate any help.

 

[Joe4]

WELCOME TO THE BOARD!

It can be done simultaneously with a macro. Here is a simple little macro that will sort the first 4 columns separately:

Sub MySort()

'   Sort first 4 columns separately
    Dim i As Long
    For i = 1 To 4
        Columns(i).Sort Key1:=Cells(1, i), Order1:=xlAscending, Header:=xlGuess, _
            OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    Next i
    
End Sub

 

[jasko]

Many thanks for that JM14, I shall try it............regards.