VBA to Sort Data in Excel - Excel VBA Tutorial

[@derryckklarkowski2269]

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!

[@ExcelDestination]

You're very welcome!

[@itdoeshurt]

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

[@ralphallengamboa9394]

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

[@SohilShah_Melodyman]

Very helpful video!😊🙏

[@enrikekasijas705]

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!

[@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 = Worksheets("Sheet1").Range("A:L")
Set specific_column = Worksheets("Sheet1").Range("J:J")
total_data.Sort Key1:=specific_column, Order1:=xlAscending, Header:=xlYes
Worksheets("Sheet1").Cells(1, 1).Select
End Sub

[@Akashpadhan]

Exactly what i want

[@romcasimiro9668]

Thanks bro but I have a question, whenever i try to enter another text such as pressing enter to go to the next cell it keeps coming back on A1 cell.

[@rbrtsparkman]

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

[@ExcelDestination]

Thanks for subscribing.

[@ajigrafi]

Thank you so much, it's work perfectly.

[@sharadmoktan6874]

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

[@alpisuanto6536]

Thank you for the instructions.

[@shubalubla]

thank you very much for the video!

[@1gopalakrishnarao]

Thank you. Very helpful. Please publish some more for the VBA learners/users/addicts/lovers.

[@ExcelDestination]

Thanks Gopala for your appreciation...let me know...if you are looking for tutorial on any specific topic in vba...I will try...till then keep watching...and please share it further...

[@MOLOKOmilk]

Thanks! Very helped me.

[@kanemac1443]

Thank you sir !

[@archanaaa2514]

Sir, how to sort total data at a time ?

[@alagurajan1787]

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

[@ExcelDestination]

you can loop through same code for all sheets. you can take help from following tutorial :
ruclips.net/video/AlC8a7KyJq0/видео.html

[@belalmusallam]

Can I used this code with date values??

[@MohAboAbdo]

Great video, thank you so much.

[@arnoldremulta8939]

Thank you....

[@DeepGill-dl3wj]

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

[@brightcomputers9326]

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

[@murtadhasafir2053]

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

[@evanbarna8454]

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?

[@evanbarna8454]

Figured out how it can sort but it's pull my data up that I am attempting to sort. How do I prevent this?

[@ExcelDestination]

Without looking at code, can not say anything. you can share your code at [e-mail]. I will try to check and respond.

[@stevennye5075]

very useful

[@bongdelicacy3158]

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

[@Aaron2108_]

How about Sort by Custom ?

[@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

[@samnangsuonsokunth8719]

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

[@samnangsuonsokunth8719]

can teach me how to find top10?

[@PremKumar-de6gr]

Thank u so much sir

[@awadheshkumarmaurya2818]

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, u,.........k,kh,g.gh). 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)

[@cfucharsadda8153]

Bundles of Thnx sir.

[@paulinavillalobosorozco9349]

i love you

[@3ddance367]

Thanks
If 2,2the same

[@dudeyme3331]

👍

[@goyaltraders3265]

Please reply me

[@ExcelDestination]

what is your question...have you sent any question on [e-mail] ?

[@ExcelDestination]

I say your comment....please send me your sample data at [e-mail], I will call you tomorrow...and will reply to your email also....thanks