VBA Tips #3 - How to Sort Data by Multiple Columns

How to Sort Data by Multiple Columns

In this video, we will learn the technique of sorting data by multiple columns using VBA.

#VBATips #TheDataLabs

Please follow the below link to download the Excel file used in this tutorial.

Thanks for watching!

Please like, share, comment and subscribe.

Have a great day!

[boscogamiz]

Not easy to find such simplicity and clarity. Thank you so much! Loved this.

[Subu]

Very nice. It should be a little loud. Please show how to give variable range

[infosatish]

Awesome VBA tips....great that you're now on with basic VBA tips. Thank you so much for starting this series; waiting for more videos in this series. And Yes! I can see now video sound quality has improved immensely! So congratulations!

[GhostRider-mzhl]

Just looked at you're tutorial, do you have a vba code to sort a row in any range on the sheet? ie sorting in ascending order to sort ie 2, 4, 1, 3, 5 in ascending order from left to right (ie in A, B, C, D, and E), also the second version will have a space in between each number ie A is the starting point followed by C, E, G, I, thank you. With regards Ghost Rider

[benlee]

At about 5:06 minutes into your video you mention you can make it "dynamic so that excel will automatically identify the last column". Can you tell me how I would make it "dynamic" and not a set end range?

[archanaaa]

Hello sir, I dint understand one thing. Why did you write d set range.range ( ) at last? What's d use of dis

[marcocammarata]

.set Range("A1").CurrentRegion ' dynamic range