VBA to Sort Data in Excel - Excel VBA Tutorial

This example explains simple vba code for data sorting. VBA Macro to sort data in descending order and ascending order with easy example.

[derryckklarkowski]

Thank you. I searched many sites with no success. This video gave me the information I needed in a beautifully simple and clear manner. Worked perfectly. Much appreciated!

[itdoeshurt]

3 rascal fiverrrs couldnt do this simple trick for me,
u saved a life today, thank u and bless u...

[ralphallengamboa]

Its my first time to know about the Developer Tab, thank you for video Tutorial, you nailed what I came for.

[ajigrafi]

For anyone who want to run Macro without any button, this the code:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Dim total_data As Range
Dim specific_column As Range

Set total_data =
Set specific_column =

total_data.Sort Key1:=specific_column, Order1:=xlAscending, Header:=xlYes
Worksheets("Sheet1").Cells(1, 1).Select


End Sub

[enrikekasijas]

Dude you are the best 😂 I have been wasting my time with AI...they give me like 20 lines of codes which don't work. Grrr
You made it 10 times easier and I finally get it 😮 Thanks!

[rbrtsparkman]

Thanks for this video. I'm subscribing because it is literally perfect.

[sharadmoktan]

What is the VBA code to high light the list box data based on conditions

[gopalakrishnarao]

Thank you. Very helpful. Please publish some more for the VBA

[ajigrafi]

Thank you so much, it's work perfectly.

[archanaaa]

Sir, how to sort total data at a time ?

[alagurajan]

Hi. Please suggest. How to enhance this for all the worksheets in the workbook. Please help sir

[murtadhasafir]

I would like to know how to sort multiple columns in table format with a single click.

[brightcomputers]

Sir it is a very nice but i am just curious that whether it is implement in automatic process to sort the data? If yes then please give the process

[evanbarna]

I am not a saavy vet when it comes to VBA, this button is not working for me. It simply highlights cell A1, A1 when I click the button. What did I do wrong?

[AniManuSCh]

How can be sorted when condition is met and toggle between ascending and descending? for example: when a header cell is selected or doble clicked then sort that column in an ascending way by default, but if it is already sorted that way, then sort it in descending way instead

[belalmusallam]

Can I used this code with date values??

[DeepGill-dlwj]

I am getting 'sort method of rante class failed ' error... Kindly advise

[awadheshkumarmaurya]

Thanks you sir/bhai. I request you make a video for a sorting /arranging candidate names as per criteria given in panchayat election (Hindi alphabetically (a, aa, e, ee, I try more time but failed as I am weak in Language coding. it can be done by VBA only as it is based on criteria ( precedency of Letters)

[bongdelicacy]

Thanks for this tutorial. Can u pls explain if sort to be oldest to newest then what should be the code?

[samnangsuonsokunth]

can you teach me how to find top 10 in vba code?