Help sorting in Excel

jerbear 

A small solution would be a VBA solution like the one in the attached file. Is only an additional suggestion 🙂

Sub Sort()
Dim strSpalte As String
Dim strBereich As String

'Parameter
strBereich = "A1:B11" 'Area
strSpalte = "A"  'column

'Sort
With Tabelle1 'Sheet
Range(strBereich).Sort _
 Key1:=Range(strSpalte & "1"), Order1:=xlAscending, _
 Header:=xlYes, MatchCase:=True
End With
End Sub

If you liked one of the suggested solutions, please click on it as the correct answer, if possible with a like (thumbs up). If none is the solution you are looking for, please give us a quick feedback.


Best regards,
Nikolino
I know I don't know anything (Socrates)