Excel Macro - Sort Data, Dynamic Range - Excel VBA Part 12

Learn how to make recorded Excel macro that sort data work.

This tutorial is Part 12 from Excel VBA Programming - Beyond Recording Macros series.

#excel #macro #vba

[immanuelsuleiman]

you are an awesome person for sharing your knowledge
i am starting a data analyst position on Monday
they wont let me use c# so i will have to use vba
i honestly think its a terrible language but they way you explain things makes it so much more accessible
thank you so much
PS. your google sheets JavaScript tutorials are also awesome

[MyRockMyFortress]

Extremely helpful video. I have always struggled with sort with dynamic range with VBA

[sreekanthsatuluri]

Yeah really after spending lot of time i saw ur video
Thanks a lot!!!

[costas]

GREAT VIDEO! And exactly what I was looking for! Such a simple explanation and answer but only if you know what the answer is! Great work and thanks very much!

[charliekey]

Excellent information tank you for Sharing

[bocobox]

thanks for your great lecture. I come here to check your latest video everyday. hopefully, see more google sheet video.

[Servants_Heart]

Perfect video. This is what I need for a daily report. Thank you much!

[Rustomhavewalla]

Excellent.
Is there any simpler method of getting the range upto the last row in data sort for different worksheets?

[aNDy-qhem]

Would be great to see comparative data sorting for same data stored in array, dictionary, collection.

[OutworldsKiller]

Good video my friend, very clear. I have a doubt: ¿What about your data starts in another range? for example: Range("B7:G35").Select or Range("C10:H15").Select or Range("D22:I44").Select. How could You manage these kind of changes?
I have seen in your range of your video (Range("A1:F22").Select), you solved it with a variable to find the last row call "lr" and your arrengement is: Range("A1:F" & lr).Select; but what if instead of that, I want to locate the first row of the data? Could it be like this: Range("A" & fr :"F" & lr).Select? Forgive me for my ignorance, I am only a begginer on this matter of macros. I hope you can help me. Greetings.

[RohanKumaar]

Sir ! How do i create a button that automatically sorts in smallest to largest order or vice versa

[ChooseHope]

So this helps me a lot, except, I have numbers stored as text which begin with a letter. Example R12345. When I do the =A1*1, it returns #VALUE. How can I copy those values in VBA?

[ameensams]

I hope you can help me with this. Say after the last row, there are some blank rows then after that, there are another set of unwanted data. Also, say at the top of the column header e.g "Transaction date" that you always want to keep there are some data that you also don't need but simply doing a Ctrl + Shift + Up won't help because there are also some weird staggered '-' characters. In a nutshell, you want to get rid of everything else before your needed header and every below where the collection of columns ends. How would you do that, please? Thanks

[ashish]

It shows #name error when i do same for percentage values

[ariespinal]

How do I run a macro in a completely different excel sheet?