VBA Tutorial 11: Auto filter in Excel VBA

Hello Friends,
In this video you will learn how to use auto filer in Excel VBA.
You will learn:
1. Filter by text
2. Filter by Number (like greater than 50)
3. Filter by “Contains”
4. Filter by “Start with”
5. Filter by “End with”
6. Copy filtered data to another worksheet
Please download this excel file from below given link:
drive.google.com/open?id=1ljV...
Learn how to enable camera functionality in excel:
• How to use Picture eff...
Dynamic graphs with the help of camera:
• Dynamic graph with Cam...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Follow me on Facebook:
/ pkan-excel-expert-9748...

[@famoraes_]

Incrível, muito obrigada!! Agradecimentos do BRASIL :D

[@mxwest]

Very good video! Very helpful and understandable....even for a beginner such as myself! Thank you!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ujjwalmaity07]

Thanks for the great content! really appreciated the lesson!

[@rizaldjufri3753]

Hello PK
The Tutorial Very helpful and understandable. thank you

[@BALJIT147]

This was exactly the information I needed, thank you.

[@PKAnExcelExpert]

Glad it was helpful!

[@hiralmistry5853]

The tutorial is very helpful, Thank you.What if we have headings on row 2? How can we get the headings on the new sheet which has filtered data?

[@SuperHanme]

THANK YOU VERY MUCH FOR THE TEACHING

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@allabout1135]

Thank You Sir! Gr8 Video!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Flywithuss]

been really helpful. thank u.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@josephblumert443]

Hi PK, is there a command that allows for automation of this after it's built instead of pressing run, maybe a refresh when the file is opened?

[@antoniobrandao1642]

Amazing video! thank you very much!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sachingaichare4599]

indeed very useful, thanks .

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wimgeerling]

PK, thank you very much for this tutorial, it really works great.
My sourcesheet has two hidden colums who are not copied, even when i use "xlPasteAllMergingConditionalFormats". Is there a possibility to solve this? Thanks in advance.
Wim

[@mahindapathmasiri6650]

Thank dear, 👍

[@PKAnExcelExpert]

Welcome 😊

[@kanbalt]

hi! very good examples! could you answer for my questions? when I use autofilter, how can I use criteria as "Date-1" to do report by yesterday numbers?

[@JustinPetersenBedrah]

What would the code look like if we wanted a second contains line? So if we wanted to see employees which contain a 1 "OR" a 6. Thanks much, I am having such a hard time filtering with multiple keywords.

[@satyambaviskar2017]

Thanks a lot buddy!

[@PKAnExcelExpert]

Most welcome

[@vilinhegde8061]

Hey anybody know, how to use this method to continuously filter and add data instead of clearing them?

[@MAQXDS]

Sir I want to apply auto filter on all sheets with dynamic criteria for example filter for any value in cell A1
Kindly Help

[@DeepakRajput-xg8ct]

Thank you sir you are great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@1668hk]

well done !

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@naveenofficial3680]

Thanks bro that was so helpful. After filter i want sort these data. How to do that??

[@ashishgoyal4166]

I love u PK. U have solved my most problems. But if i want to filter greater than and less than at sam time please tell that also

[@user-jo4ld2yg5y]

Hello PK!
Where can I view the current Table Filter settings? For example: before applying a new filter to a table, I need to remember the current filter settings. How can I view these settings and save their values in Excel cells using VBA?

[@amitsinghrajput2774]

Thanks you sir

[@PKAnExcelExpert]

Thanks for watching

[@rameshpatel-ei9kx]

sir , this is very useful video. sir, what is code for shorting in ascending order ? please suggest code for this......

[@yashsomaiya8141]

Hi PK. Can you please make one basic video on how to make pivot in VBA macro?

[@MohamedRamadan-yp1tm]

how to run auto filter VBA and protect a worksheet?can you help with any codes?

[@hiralmistry5853]

What if I write as below? how can I apply greater than or contains filter with a variable? sh.UsedRange.AutoFilter col_num, value

[@sureshjogi9626]

Dear sir, in Auto Filter contents mode how to Filter the object variable.pls suggest me

[@abdurrehman5038]

do the same for column "week", filter the data that's starting with "1".
like (1,11,12,13,14,15,16,17,18,19) ?

[@batmanfromindia7210]

In criteria how to put variable ? As I have lots of account number to search in loop... Pls help..

[@vijaysahal4556]

Nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@munshirasimraja5713]

Thanks for valuable knowledge.
I want to know how we can change autofilter value dynamically.
Please help

[@PKAnExcelExpert]

Will upload soon

[@TheKharismaNirwan]

I wonder if its possible to FIlter and then Clear Filter at the same time using VBA?

[@Flywithuss]

Hi, can you help me with a code that filters for #NA under a particular column, and once found asks for mapping the #NA. once the mapping is done, the macro will execute further.

[@Techreviwer]

Hi Sumit
I have the same issue
Did u get any solution on it

[@Flywithuss]

Kamran Almelkar sorry, not till now.

[@Techreviwer]

Sumit Kumar
Thanks for reply keep looking
If I get anything will get back to you
Thanks bro

[@AkbarBox]

good job

[@PKAnExcelExpert]

Thanks

[@hemantgoyal409]

Sir how to make this filter dynamic ..with any selected column and any content..

[@vikrampurohit3033]

Hi Sir, I need to filter a column with following values ( "U300", "N300", "U600", "N600", "Y300", "X300", "U684", "U682") and need to delete all other rows
Can you please help me to sort out this

[@balasubramanianshanmugam3721]

How to do begin with in number field column data. Thanks in advance

[@fauzanmuzakirmuhammad2989]

I have already tried that vba formula from my own file. When the source table is not empty, the filtered data is copied to blank sheet, but without header. Otherwise, when the data is empty (only header), the table is copied to blank sheet, with header. Why it happens? What is the solution of this problem? Hope you can help me to solve this. Thank you

[@ashishvariya1960]

Sir this videos was very helpful for me. I am new to VBA but managed to copy this code.
Sir have 11 columns data and need to filter out customer responses by excluding YES, NA, BLANKS from each columns starting from no 5 and copy data of 1 to 5 in next sheet. Is it possible to do this through VBA. Plz help Sir with VBA code if possible

[@ClintonCanarias]

how about filter dates? , because I have an error where I will show a dates data from March 9 to 12 but the March 11 data won`t appear only from 9,10 to 12. Also how to sort date ascending and descending?

[@amitsinghrajput2774]

Please publish one video on sort data.

[@MrPaunty]

How we can filter data using 3 wildcard charater criteria

[@sophiexu4511]

Nice video. How to write the code for 3 criteria? Your code is for searching keyword "1". sh.UsedRange.AutoFilter 3, "*1*", What if I want to Contain '1', '7' and '6'? Thanks

[@Imobajuda]

Show !!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@panchajeypore]

sir
vba me sort function kaise create kare
help me pls

[@rakeshhalpati2427]

Can we assign veriable in text filter

[@PKAnExcelExpert]

Yes, we can

[@Techreviwer]

I loved u r video and how simple u have made it for us
Could you please help me with one thing that's missing
Say I want all the employee details except emp 1
What's the code
Or say I have data and some column contents #NA
How should I select all data except #NA or say deselect #NA
Coz I have very huge data
So can u let me know the code
Thanks in Advance for help

[@PKAnExcelExpert]

Hi Kamran,
You can use "1" in criteria to select all data except employee 1 or just put before your criteria

[@Techreviwer]

PK: An Excel Expert
I will try an get back to you

[@travelvloggerprosen1460]

how to copy multiple filtered and multiple criteria full data in another shit please share

[@abhishekchatterjee5586]

Pls create a VBA for Analog Watch in excel...

[@PKAnExcelExpert]

Sure Abhishek,
Will create soon. Thanks for advice.

[@goyaltraders3265]

Sir aap ka phone no kya ha

[@ShahidulIslam-fy3bz]

Search auto filter option make

[@asishsaha2269]

Too much blur screen

[@hellmutmatheus2626]

Thanks for the great content! really apreciated the lesson!

[@PKAnExcelExpert]

Thanks for your valuable feedback