Thread: batch sort

I think you would need to use VBA - either iterate the data set and apply the Sort on a row by row basis or push the data into an Array and sort the Array before pasting back to the sheet.

The former is perhaps more obvious to work through and with 4000 lines of data (I:M) should not prove too slow ... in basic terms:

Sub Example()
    Dim rngRow As Range
    On Error Resume Next
    Application.ScreenUpdating = False
    With Sheets("Sheet1")
        For Each rngRow In .Range(.Cells(2, "I"), .Cells(.Rows.Count, "M").End(xlUp)).Rows
            With rngRow
                .Sort .Cells(1), xlAscending, Orientation:=xlSortRows
            End With
        Next rngRow
    End With
    Application.ScreenUpdating = True
End Sub

Modify sheet & range references etc to suit own requirements.