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