Excel VBA: How to Sort Data with VBA Macro
Вставка
- Опубліковано 6 вер 2024
- To get the code in this video visit www.bluepecantr...
This video explains how to write a macro that will sort data. The examples given explain how to sort on one column and multiple columns - including sorting by more than three columns.
------------------------
You are one of my favorite tutors. No long intro, just to the point with easy to understand examples. Perhaps my pet peeve is when someone says I'm just going to give you a quick video then follows with a long fancy intro.
I agree, I am not a fan of time consuming intros and graphics. I try and be as straight-to-the-point as possible, for you busy people.
Perfect tutorial. Brief. Clear. Precise. Logical. A diamond in the coal mine of VBA tutorial videos.
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.
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
I have been getting an error in creating my sort code. After searching for along while I found your video and you solved my problem at 1:26! The key is only the top cell in the range, not the entire range. Much appreciated!
FINALLY! I've been looking for this exact type of tutorial for hours (weeks? lol). Thank you!
Great Tutorial. I look for a lot of other tutorials and this was the easiest and best of all
It is soo small. I suggest that use bigger fonts or smaller resolution. Please
Can we just display only Cash records or only Debit card records?
How do you create a custom order in the environment?
Just what I needed!
I prefer to use cells(1,1) instead of range.
It works.
thanks.
Can you please help me on how to sort more columns using vba
Hey Chester all above sounds good, But I want to sort with VBA only one column. the column is K7 and with two headers K5 & K6, Anyway the sort have to start from K7 and down as K2507. See if your info works, thanks mate (Ascending alphabets)
sir can you teach me how to find top 10 with this vba code?
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.
Hi, Your video is clear. i have a doubt, will you please explain it? I will ask it based on this video data. @ 07:59 , you get store ID in a sequence (like 11111..2222....3333....444....). My question is, how to get the first and last row of STORE_ID of 1 only and how to copy it to another sheet.
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.
I got syntax error : key1:=Range("Pay_Type"),order1:=xlDescending, Header:=xlYes
Expected Expression :=
Thank you very much! You've helped me bunch!!
You are a Saviour!! Thanks. Simple and effective codes.
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
Interesting
Sir , if d range starting from a18 , den what we need to assign? A18.currentregion? Or wat
Thank you.
Thnx
how do you automate this code without having to open "view code" and pushing play?
You add a macro to a button.
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
Perfect !
Great video! Helped out a lot!
Just what i needed too.. thanks you very much!
Nice job explaining the sorting!
Awesome tutorial. Cheers.
Exactly what I need. Thanks 😊
Really helpful
excellent information, well presented!
Thanks a lot for such as wonderful tutorial.
Thank you!
Amazing, congrats
Thanks bro ! u help me.
hard to read great code for nothing
Thanx