Excel VBA: How to Sort Data with VBA Macro
Vložit
- čas přidán 8. 02. 2017
- To get the code in this video visit www.bluepecantraining.com/port...
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.
------------------------ - Jak na to + styl
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.
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!
Nice job explaining the sorting!
You are a Saviour!! Thanks. Simple and effective codes.
Great Tutorial. I look for a lot of other tutorials and this was the easiest and best of all
Awesome tutorial. Cheers.
Exactly what I need. Thanks 😊
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 very much! You've helped me bunch!!
Just what I needed!
thanz was trying to find the command, you explained it in a simple way
excellent information, well presented!
Thanks a lot for such as wonderful tutorial.
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
Great video! Helped out a lot!
Just what i needed too.. thanks you very much!
Thank you!
Amazing, congrats
Thanks bro ! u help me.
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
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.
I prefer to use cells(1,1) instead of range.
It works.
thanks.
Sir , if d range starting from a18 , den what we need to assign? A18.currentregion? Or wat
Really helpful
Can you please help me on how to sort more columns using vba
Very nice but you should use a lower resolution so that text can be seen larger. Thanks.
Perfect !
How do you create a custom order in the environment?
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)
Can we just display only Cash records or only Debit card records?
Thank you.
sir can you teach me how to find top 10 with this vba code?
I got syntax error : key1:=Range("Pay_Type"),order1:=xlDescending, Header:=xlYes
Expected Expression :=
Thnx
It is soo small. I suggest that use bigger fonts or smaller resolution. Please
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
how do you automate this code without having to open "view code" and pushing play?
You add a macro to a button.
Thanx
hard to read great code for nothing