You will Never Use Advanced Filter the same way after watching this | Excel VBA

A better way to use advanced filter using VBA code and with just 9 lines of code. It is so easy to implement that you will never want to filter data using the traditional methods.

Detailed explanation of each line of code with comments added for your future reference

Code Snippet & Data Used:

Visit my blog for more content :

Affiliate Links --

Learn Excel from scratch for beginners (affiliate):

Best Web Hosting Service :

Cool tech that I use for these videos :

#Microsoft
#excel
#exceltutorial
#vba
#advancedfilter
excel advanced filter,advanced filter in excel,advanced filter,excel vba,excel advanced filter copy to another location,excel,advanced filter excel,excel advanced filter multiple criteria,advanced filter vba,vba advanced filter,excel filter,advanced excel,how to use advanced filter in excel,vba excel,excel advanced filter vba,advanced filter or criteria,advanced excel vba,learn advanced excel vba,excel vba for advanced learners

[muhammaddilshadshad]

Love you boss
This code indicates of your finest and professional skills

[abdulsalam]

Liked it. I have to check with my data.. thank you sir

[pintshhh]

very good video and lots of information about codes.

i watch lots of video about macro and advance filter but not get with subtotal or and criteria with sum

In your data sheet there is a value in their can we sum that value every time with filter data?

[karthikeyanmohan]

Super bro. It works amazing. But for me first lines are blank then publishing the data

[tiozaogaimero]

Excelent. How I filter a date extracting the month? Exeample: a date in format 08/07/2024, when i chose a month number (3, 5, 7) apply the filter

[patfans]

Thanks a million for sharing this! It's been very helpful and can speed up heavy advance filtering tasks that I have. A couple of questions for you. Is there a way to create a clear button? My filtering criteria can include up to 7-10 columns/items at times. Also, you said drop downs lists can be used. Adding a drop down list with up to 10 columns of criteria won't get in the way of the code? Thanks for your help my friend!

[flamingowashingmachine]

Hello, first of, thanks for your tutorial. It's really helpful ❤. I have one question though, how come my filtered data doesnt retain the original format like yours?
Thanks.

[paulturner]

How about extending the tutorial to include the Unique:= True parameter?

[ashishagrawal]

I want the output copied for only selected columns not all, how this can be adjusted to view only few columns ?

[Bartlefevere]

Hi,

Thanks for the code. It is working like a charm.
I would like for example when entering a value in cell H2, that it filters also a partial match and not only when the value starts with the value entered. Is this possible? In other words, it would be nice when the criteriarng starts with a “*” and ens with a “*”.