The Ultimate Excel Advanced Filters In VBA [Full Training Course]

In this week’s training, I will show you the Ultimate Advanced Filter Guide in VBA.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 – Introduction
0:36 – Overview
20:45 – Change Event Worksheet
37:46 – Run Filter
47:37 – Clear Filter

JOIN OUR COMMUNITY:

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #ultimateadvancedfilters #advancedfilters #excelvba

[faybowers]

Your tutorials are the best I've ever seen presented by anyone on any subject. The fact that you also provide the supporting documents is incredible. Thank you, thank you, thank you.

[ranjitjojo]

You are the best teacher i have seen so far.... who takes time in explaining every piece of the formula, the logic and most importantly the vba

[ericboateng]

Painstaking tutorials covering contemporary essential topics with top-notch presentation & clarity! ...all free on youtube! ...yea, most valuable stuff, like fresh air, are FREE! ...Thank you Randy! This guy is AWESOME!!!

[grahamparker]

Love watching your videos Randy, keep up the great work 👌🏻

[armotxa]

Thanks to you, my app getting more and more advanced !!! thank you again

[SyedMuzammilMahasanShahi]

Lovely. Just amazing. Thanks Randy for this beautiful video

[majlex]

you are the best teach. this help me a lot.

[linusedward]

Yea one of the best informative training, thanks

[VenemAcademy]

Hi Randy, again great instruction. Thnx! Q: about copy back the results to user view, does it speedup the process (and with less code) if CurrentRegion (with an offset) is used?

[peterwesterhout]

Thank you very much. You are my (VBA) hero. I only have a problem with advanced filters with numbers.

In your example i cannot filter on zip code or a part of the zip code. Do you have a solution for that?

[XuanNguyen-syjl]

Hi, thanks, very helpful material. But may i ask how you make the words in Sheet1.Range("D7:N8"), can be grey color and Italic when it includes ":"?

[rogervoisard]

Hi Randy, thanks for this awseome video. I tried to adapt it for my purpose. I'm stuck with a problem.
When you have dates or time fields which are empty in the DB the filter on other fields dont show this datas.
Is there a way to handle this?

[robertw]

Well. What it only needs is the second title. So, filter in place, place the two find rows below your title and hide them include the second title row. So, you only have the one Date column. But if you change the title of the column next to the Date, you can then change the title of the column next to it and the Find row title to Date also, run the >= Date and <=Date and change the titles back to what they originally are for the second Date column. It's like creating a virtual From and To Date. So, you have very little code to do this and no extra elements showing on your page. It's all self-contained.

[bigE]

Awesome training! If I have data by week for multiple customers in a closed workbook and I want to import certain weeks for a particular customer into my active workbook, is there a way to use advanced filter to do that ? I’m other words I don’t want to import all customers and all weeks then import I only want to import the data that meets my criteria so the criteria and copy to range would be in my active workbook and my data range would be in the closed workbook.

[Pikkemandsten]

Is this file available in your 100 workbooks file?
Asking cuz I find it useful but im focus on your master class training for now :) btw I love that masterclass! Learning new creative ways and afterwards I can plug and play! Thanks Randy!

[Yul]

Great video. But can i ask? How can I add more column and still can use it?

[muhammadafzalbughio]

Hi, can you tell me how to open these models in a software like design instead of excel file or excel background?

[bhushangosavi]

Thank you Randy, However I am Unable to filter the "Less than" and "Greater than" Numbers. It doesn't show any error, but it doesn't filter as well.

[sasifexcelsolutions]

Hi Randy, hope you well, i know i know its 3 year later, however, i struggling to get tge source data from outside workbook. Looking for code the will open the external file run tge advance filter and close the external workbook. Thank you

[irfanahmad-itbp]

Thank You Randy, i have data with around 25000 rows and it take a little bit time to filter, How i can speed up code "RunFilter".