VBA: Filter Data with Multiple Values

#xlFilterVaules #VBA #FilterWithMultipleValues
In this video you will learn how we can use an excel range as a filter criteria and paste the filtered data on another worksheet.

Please download this excel dashboard from below given link:

Purchase our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

[elguensamaritano]

this men deserve a very special place on haven, you make a great work thanks

[biplabbaishnab]

Ended my search on filtering here. Well explained brother, keep going

[aniketbhalerao]

PK thanks a lot, speed is perfect not too slow not too fast, easily explained functions. :)

[GerryStilton]

Just what I needed. Thanks PK! I thought autofilter syntax, the ARRAY was for the Excel formula Array rather than the vba array data structure type. That cleared it up.

[shahir]

Dear PK,
Excellent presentation
Really helped
Thank you very much

Expecting many more videos like this...

[denverjamesduran]

Thank you I was searching the whole web for this!

[juliussamaniego]

Thanks a lot! You have no idea how this video has helped me! Thank you, you're a crack!!

[craigvoss]

Great job. I always appreciate your videos. Thank you for sharing your knowledge with us.

[ghuskia]

Excellent.. Thank you.. Please make more of it on vba pivot table

[Calabrel]

This VBA script worked great. Thank you for the video.

Question, if you wanted to invert the filtered data so that you copy/paste the data that isn't listed in your Filter_Criteria_Sh, how would you go about doing that?

It would be very beneficial to be able to exclude things I want to copy with a list.

[ashwinpadhy]

Thanks a lot for help also visited your website and it help a lot. Do you provide learning for VBA. Would like to learn more.

[birkanal]

Hello, can we transfer your work in this video directly to the listbox instead of the page, thank you.

[gregandcindylaporte]

Hello, your video is very straight to the point and I will use most of the coding. However, i need some help around the Filter table section. I do not want to "hard code" it. I want to Copy a value from one cell on another sheet and paste it on the Auto Filter criteria. Any thoughts or links you may have?

[ashishagrawal]

Thank you. How to restrict only selected column to be copied in Output sheet. I need only few columns in the output. how vba query should be adjusted

[WADiverDave]

Hey - thanks for the tutorial - I have an issue where I need to filter out multiple criteria - is there a way that I can use the Array for <> to - for your example filter out...<> EMP1, <>EMP2, <>EMP3...? Thanks David

[maheshnelapati]

Hi PK, Excellent video, I have a doubt, I want pass input at a tie from multiple fields of Filter
_Criteria sheet to data sheet to filter . And the filtered data I want to paste in to Output sheet.Could you please tell me how to do that

[salahlechekhab]

hello, thank you, i need filtred by years in output exemple: 2018-2019-2020

[Andrea]

Thanks!
I have only one problem:
I have a table where there are empty cells and the filter is hiding all the rows which don't contain the complete data.

Example:
In a table with headers "Date, Description, Category, Amount, Notes", when i search "Food" the filter doens't show the rows in which the "Notes" cell is empty.

How can I make the filter also show me rows with some empty cells?

[Achiuce]

how to let VBA allow to return a normal range if the criteria is empty? I'm trying to implement such a system for an entire database. If I don't want to put a criteria under one field. I still want it to return the ones I have inputted cells to. Any help is much appreciated

[srinivasv]

Hi, I am unable to filter using criteria *value using vba. Please share your thoughts am using Excel 2013