Excel Userform Advanced Filter with Multiple Criteria

Excel Userform Advanced Filter with Multiple Criteria tutorial. This Video tutorial will deal with creating a multiple criteria advanced filter that run from a userform. You will be able to leave criteria blank and the filter will still work successfully.
The userform can run from any worksheet so as not to show the source data.

[jcmichaelw]

I'd been trying for weeks to do the same thing but with the AutoFilter mechanism. In less than 30 minutes, you've shown me how to do exactly what I need to do. SIMPLY AMAZING!!! Thank you!!!!

[Bulkmeister]

Once again Trevor another entertaining and informative tutorial of the Excel VBA variety that enhance our learning, Looking forward to the next offering.

[RahulBhojwanipro]

Sir, Thank you so much! You are one of very few worth calling "Sir"!

[napsterwherenayou]

hi sir trevor..do you havea completed and ready to use template for your project?thanks

[janezklun]

Just great video, cleary explained, with nice graphics,
Thank you for sharing your knowledge

[millydog]

Great Project, work so well. If using numbers rather than words as the data source, is it possible to have partial filtering

[anacrob]

Trevor, GREAT EXPLANATIONS, CONGRATULATIONS, YOU ARE MORE THNA GREAT!
I Have got two questions:
1. What about having 14 columns to show? Is it still possible?
2. I reproduced everything on my pc. All perfect except the “Columns Head”; actually in your example the Columns Headings are properly shown in the framed cells, while on my pc (WHY???) they are shown as a first line of the ListBox

Thanks and congrats again for your clarity
Roberto

[danielkibby]

Thank you so much for your help. You're a life saver.

[juandisiregar]

It is amazing tutorial, but i can not running row source "FilterData" in ListData form, it sound " could not set the RowSource property. Invalid property value". I am using Excel 2013. Please help me Sir... Thank you.

[GraceMichaels]

Is there a tutorial that shows the vba code to export the list box to a new worksheet?

[GraceMichaels]

Can I export the data to a new worksheet after I apply the filter?

[sahajamalsekh]

please link, to get this work book. it is not available in your web.

[marthagourd]

Hi Trevor - Thank you so much for these 2 tutorials. I was hoping you might be able to do a similar tutorial which uses 5 Multiselect listboxes to autofilter a set of data?? Any help or pointers would be very much appreciated!

[AshishKumar-ukgi]

Hello Sir, all your videos are easy and very useful to understand. If you give Excel file download links for practice, then thank you very much.

[Knych-nrot]

Thank you Trevor, I tried the Filter data using wildcard in office 2007 but it does not give me any results when the cells are empty so I can only use 1 button to filter even if there are multiple search combinations. Any suggestions will be much appreciated!

[tedtdu]

(in my Project) Error occurred when running the Advanced filter. How to deal when error occurred during the filtering?

[lorencbellovoda]

Could you please explain me more about "Filter Data" at the end of the code.
Me.ListBox1.RowSource = "Filter Data" . This code doesn't work. could you.

[XLSavvy]

Hi Trev,
Amazing work but i am struggling to get filtered data within the date frame.
lets say,


if i put 06-Jun-2013 in start date and 16-Jun-2013 in finished date . userform only picks the finish date filter the below data rather than filtering between dates.

can you please advise on filtering between dates (Start and end)...

[dasarinareshchiru]

Sir, Can u Please share file to download

[hrmnpsrffn]

Your website is not working and your last post was like 4 years ago. I hope you are okay.