Sorting a column datas

[RENU1973]

Actually,I want to sort my attach file of column K in descending order and alongwith column B in ascending order.
Will it be thru VBA codes? Any help highly welcome.
Please see the result as next sheet i.e.'Result Display'.

[HansV]

You can do this in the interface:
On the Home tab of the ribbon, click Sort & Filter | Custom Sort...
Select 'Chk. digit' from the Column dropdown, and select 'Largest to Smallest' from the Order dropdown.
Click Add Level to add a second sort level.
Select 'Vendor' from the Column dropdown, and select Smallest to Largest' from the Order dropdown.
Click OK.

If you prefer a macro:

Code: Select all

Sub SortList()
    Range("B5").CurrentRegion.Sort Key1:=Range("K5"), Order1:=xlDescending, _
        Key2:=Range("B5"), Order2:=xlAscending, Header:=xlYes
End Sub

[RENU1973]

Actually,I am learning both excel and VBA codes at the same time.You have suggested me both answers. Thanks Hans for your quick response and steps wise guidances.