Excel VBA: How to Sort Data with VBA Macro

sir can you teach me how to find top 10 with this vba code?

how do you automate this code without having to open "view code" and pushing play?

hello!
I want to sort odds and even numbers combination in ms excel 2013 i have a list of 2 million combination my combination are mixed and i want to sort them for example
(3 odd 2 even numbers all combination together , 4 odd 1 even numbers all combination together , 2 odd 3 even numbers all combination together
1 odd 4 even numbers all combination together) the list i have create is for lotto i have 5 numbers combination from numbers 1 to 49 numbers for example
i want to sort like this from the mixed combination list if any vba code or formulas you know sir kindly tell me it would be a great help thanks.

1-3-6-40-41
1-3-6-40-43

1-3-6-40-42

1-3-6-40-44

3-9-15-17-40

3-9-15-17-42

3-6-24-34-44

3-6-24-34-46

Is there a way to make it automatically run whenever you update the data ? or would i have to keep opening the code and pressing play

Can we just display only Cash records or only Debit card records?

How do you create a custom order in the environment?

Thnx

FINALLY! I've been looking for this exact type of tutorial for hours (weeks? lol). Thank you!

Thanx

Perfect !

Thank you.

Great video! Helped out a lot!

Perfect tutorial. Brief. Clear. Precise. Logical. A diamond in the coal mine of VBA tutorial videos.

I got syntax error : key1:=Range("Pay_Type"),order1:=xlDescending, Header:=xlYes

Expected Expression :=

Just what i needed too.. thanks you very much!

Great Tutorial. I look for a lot of other tutorials and this was the easiest and best of all

I prefer to use cells(1,1) instead of range.
It works.
thanks.

hard to read great code for nothing

Just what I needed!

Can you please help me on how to sort more columns using vba

Thank you very much! You've helped me bunch!!

Really helpful

thanz was trying to find the command, you explained it in a simple way

Very nice but you should use a lower resolution so that text can be seen larger. Thanks.

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

Sir , if d range starting from a18 , den what we need to assign? A18.currentregion? Or wat

It is soo small. I suggest that use bigger fonts or smaller resolution. Please

excellent information, well presented!

You are a Saviour!! Thanks. Simple and effective codes.

Amazing, congrats

Exactly what I need. Thanks 😊

Thanks a lot for such as wonderful tutorial.

Is it possible to sort a table which uses a formula to fill table rows/columns in VBA? I.e. I have a table which uses vlookup to find values to insert into the table and then I want to sort them

Thanks bro ! u help me.

Hello. Thanks for a very helpful video. If I wanted to sum up the tran_value for every pay_type in another sheet, would that be possible? Without using a pivot table.

Thank you!

Awesome tutorial. Cheers.

Nice job explaining the sorting!

This is really useful tutorial, thank you. Clear and to the point; without any waffle. My one suggestion for improvement would be some sort of zoom functionality for future videos - the actual code can be a bit hard to read at that distance depending on screen resolution. Again great job.