Excel VBA: How to Sort Data with VBA Macro

preview_player
Показать описание
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.

PFunk-ktgc
Автор

Perfect tutorial. Brief. Clear. Precise. Logical. A diamond in the coal mine of VBA tutorial videos.

stanleyroot
Автор

FINALLY! I've been looking for this exact type of tutorial for hours (weeks? lol). Thank you!

mattirons
Автор

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!

deejayohdumb
Автор

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.

BluePaperUmbrella
Автор

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

Tranterc
Автор

Great Tutorial. I look for a lot of other tutorials and this was the easiest and best of all

carlosmujicanunez
Автор

thanz was trying to find the command, you explained it in a simple way

manishudeshi
Автор

Thank you very much! You've helped me bunch!!

faelrodrigues
Автор

You are a Saviour!! Thanks. Simple and effective codes.

pralhadshetye
Автор

I prefer to use cells(1, 1) instead of range.
It works.
thanks.

seckinbilgic
Автор

Just what i needed too.. thanks you very much!

albe
Автор

how do you automate this code without having to open "view code" and pushing play?

seascapes
Автор

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.

gzimrama
Автор

Can you please help me on how to sort more columns using vba

ravitejareddy
Автор

excellent information, well presented!

stevennye
Автор

How do you create a custom order in the environment?

elbourko
Автор

Can we just display only Cash records or only Debit card records?

bcoa_sanketberad
Автор

Thanks a lot for such as wonderful tutorial.

pralhadshetye
Автор

Very nice but you should use a lower resolution so that text can be seen larger. Thanks.

andychavez