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!!!!
@Bulkmeister123
9 жыл бұрын
Once again Trevor another entertaining and informative tutorial of the Excel VBA variety that enhance our learning, Looking forward to the next offering.
@millydog8255
8 жыл бұрын
Great Project , work so well. If using numbers rather than words as the data source, is it possible to have partial filtering
@RahulBhojwanipro
8 жыл бұрын
Sir, Thank you so much! You are one of very few worth calling "Sir"!
@anacrob
6 жыл бұрын
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
@napsterwherenayou797
7 жыл бұрын
hi sir trevor..do you havea completed and ready to use template for your project?thanks
@juandisiregar
6 жыл бұрын
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.
@Knych-nr4ot
7 жыл бұрын
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!
@OnLinePCLearning
7 жыл бұрын
Hi The wildcard can only be used for text for dates and numbers use >1 or similar. Trev
@janezklun
9 жыл бұрын
Just great video, cleary explained, with nice graphics, Thank you for sharing your knowledge
@GraceMichaels
7 жыл бұрын
Can I export the data to a new worksheet after I apply the filter?
@marthagourd
9 жыл бұрын
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!
@OnLinePCLearning
9 жыл бұрын
+Morph G sorry I do not have any think that does that. Please accept my best wishes Trevor
@marthagourd
9 жыл бұрын
+Trevor Easton Thanks for replying Trevor - I did manage to cobble something together in the end, which allows me to autofilter using a loop which runs through all multiselect listboxes and then refreshes the listbox which displays the dynamic filtered listbox results most of which is all based upopon your excellent tutorials!! and Other kindly excel folk on forums! Thanks again!
@XLSavvy
7 жыл бұрын
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)...
@OnLinePCLearning
7 жыл бұрын
Hi Muhammad, This tutorial may help with that. www.onlinepclearning.com/vba-advanced-filter-multiple-criteria/
@XLSavvy
7 жыл бұрын
Thanks for your time Trev much appriciated
@GraceMichaels
7 жыл бұрын
Is there a tutorial that shows the vba code to export the list box to a new worksheet?
@lorencbellovoda568
6 жыл бұрын
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.
@tedtdu
8 жыл бұрын
(in my Project) Error occurred when running the Advanced filter. How to deal when error occurred during the filtering?
@sahajamalsekh6916
6 жыл бұрын
please link, to get this work book. it is not available in your web.
@AshishKumar-uk9gi
5 жыл бұрын
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.
@hrmnpsrffn
Жыл бұрын
Your website is not working and your last post was like 4 years ago. I hope you are okay.
@tedtdu
8 жыл бұрын
Even adding following codes Name: FilterData Refers to: =OFFSET(FilterData!$C$9,,,COUNTA(FilterData!$C$9:$C$10000),9) RowSource: does not recogning that FilterData What is wrong Sir??
@OnLinePCLearning
8 жыл бұрын
Hi Ted, You should check that the named range is working in the Named Manager. There is a support page on my website where I can be contacted if you are having difficulty with a project. Best wishes Trev
@dominiquekostler238
7 жыл бұрын
This Advanced filter is only using the "OR" Operator. How would I use it with an "AND" Ooperator and an "OR" Operator at the same time?
@OnLinePCLearning
7 жыл бұрын
Hi, In this tutorial I show you how to use AND by putting the headers horizontally and the criteria the need for heaters. You can use the OR operator by having your header and then multiple criteria below. You can combine these two by having multiple headers horizontally and multiple criteria vertically
@QaziAsif
7 жыл бұрын
hi Brother are you there??
@dominiquekostler238
7 жыл бұрын
which one are you asking? :D
@QaziAsif
7 жыл бұрын
i am asking from easton if you have idea about this advance filter kindly tell me
@OnLinePCLearning
7 жыл бұрын
Hi Qazi, What is your question?
@danielkibby6601
7 жыл бұрын
Thank you so much for your help. You're a life saver.
@TheChibisu
8 жыл бұрын
Is the form available as template?
@OnLinePCLearning
8 жыл бұрын
Hi Juan, The template is here. www.onlinepclearning.com/excel-advanced-filter-multiple-criteria/ Best wishes Trev
Пікірлер: 48