How To Filter Excel Table Data Just By Entering Text In The Header

[@ExcelForFreelancers]

😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment

[@RubinGnoni]

I always wanted to learn VBA but every tutorial I found along the way, including books, scared me and I gave up. I saw one of your videos by accident and now I'm trying to watch them all. VBA still hard to understand, but you have a sweet way to put it on your videos and I'm glad I found you. Thank you very much for sharing.

[@ExcelForFreelancers]

Wow what a great comment. Thanks so much. I REALLY appreciate that. :)

[@bp1251]

Not typically one to spend my time commenting on things on KZbin but this was a really great video and as someone with basic programming knowledge easily walked me through the steps of this useful tool so I could rework/implement it on my spreadsheet. Thank you much for the help!

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much for your comment. Much appreciated

[@ExcelForFreelancers]

⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack

[@michaelsvenson2456]

I´ve said it before, impressive work. Nice to here "why" that code is there and "what" is doing, perfect..

[@ExcelForFreelancers]

For sure, you are very welcome Michael and glad you enjoyed the training.

[@adriantoma9796]

I liked so much your tutorials. I started to check them one by one, very useful, each one can show you at least a few new things. Beautiful!

[@ExcelForFreelancers]

Thanks so much. I try to do something very different, hopefully that people have not seen. Also feel free to join our facebook group here bit.ly/groupexcel and facebook page here facebook.com/ExcelForFreelancers/ Much appreciated

[@chanmonanrie6898]

My journey of learning with you has been indeed satisfying and very much enjoyable. Thank you so much, Randy, from the bottom of my heart!

[@ExcelForFreelancers]

For sure, you are very welcome Chan I am happy to help

[@ccmoradia]

In routine work it is most important to find the values form the dataset. This is the best tutorial I have seen as of now.. Keep doing the great work. You are helping too many.

[@ExcelForFreelancers]

Hi thanks so much I really appreciate that. :)

[@bernlabs2047]

I am very much interested to follow your videos. I am willing to study this VBA. Hoping I learned a lot. Thank you very much

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount

[@DaveH3009]

Just found your channel, it's great. One suggestion (which you may have passed on for a valid reason) for this video would be to use ternary operation instead of If->Then->ElseIf->Else=>End. Example: ConName = IIf(.Range("E5").Value = "Enter Name", Empty, .Range("E5").Value)

[@ExcelForFreelancers]

Thanks so much, I do appreciate the suggestion. I will try to use that in the future. That condenses and streamlines the code much better. I really appreciate your feedback. Your expertise would be extremely helpful in our Facebook Group so please consider joining and helping out here: bit.ly/groupexcel

[@georgemantafounis1393]

Tnank you from Greece George.Very Good work.

[@ExcelForFreelancers]

Thanks so much George, I am glad you liked it.

[@tajsay]

Thank you so much Excel For Freelancers . I really enjoyed the videos and learned a lot. Thanks again.

[@ExcelForFreelancers]

For sure, you are very welcome Sayyad.

[@donfillenworth1721]

Another great video and spreadsheet. I just found this channel last night and I’m hooked! Thanks for sharing!

[@ExcelForFreelancers]

Thanks so much Don, very glad you are enjoying the videos. I try to make sure they are unique, Thanks again, Randy

[@belibikouohchristian6337]

Hi Randy. Very helpful. I have applied this on an excel project and it’s amazing. When done I will share. Many Thanks for your help.

[@ExcelForFreelancers]

Thanks so much Belibi, I am so glad you enjoyed the training and look forward to seeing the applications and solutions you will be creating.

[@kerlosnaguib1390]

sir,you are best of the best.really i like all your tutorial .thanks

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Kerlos. Check out the new touchscreen POS video I released yesterday here: kzbin.info/www/bejne/Z6ncp5ylirVrgtU

[@prakashsrinivasan7840]

Very easy and excellent tutorials thanks a lot👍👍👌👌

[@ExcelForFreelancers]

For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.

[@bulbulahmed3098]

Dear Sir, I say from Bangladesh, After learn Basic Excel From your Tutorial, Then contact to you & learn your secret system. Insha-allah.

[@ExcelForFreelancers]

Keep it up, and thanks very much.

[@dipakjangam6018]

This actually wanted from months thank you

[@ExcelForFreelancers]

Hi and thanks I am really glad I can help. Thank you for your Likes, Shares & Comments. It really helps.

[@SyedMuzammilMahasanShahi]

Your work is exceptional. I love it so much. Thanks for sharing.

[@ExcelForFreelancers]

Thank you Syed, very kind :)

[@chuckhamdan1283]

Thank you Randi for your prompt reply. As we are approaching Thanks giving, I would like to wish Happy Turkey day! :) All the best.

[@ExcelForFreelancers]

Thanks so much Chuck, Much appreciated. I will have to get a big Turkey this year. :)

[@pradeeprajselvaraj]

Thank you sir very useful videos👌👌👌👌👌 frm india

[@ExcelForFreelancers]

Most welcome! I am happy to help.

[@prabhatrawat4568]

Nice tutorial. Have a quick question, in this when you typing any thing it is filtering that data and selecting the filtered rows. Any way that it doesn't select those filtered rows? The issue suppose you want to use multiple filters then after applying first you have to click somewhere to unselect and then again. Thanks

[@ExcelForFreelancers]

HI and thanks I am not sure I understand your question, however what we can do is have VBA select another cell right before the macro ends, such as Sheet1.Range("A1").select This way the user does not have to select another cell and they can select the same cell over and over again. I hope this helps and thanks so much.

[@chrisk.2957]

Cool and useful idea, thanks a lot Randy!!!! Only the date filter is not working...even in your sheet. Any fixes? Thanks and cheers, Chris

[@ExcelForFreelancers]

Hi and thanks very much. If the data filter is not working it may have to do with your regional settings. Make sure that the date formats are all the same as your system date formats. I hope this helps and thanks so much.

[@mansoorahmed2484]

Nice training!!!, Thanks!!!!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@sonjoyroy7]

Thank you so much for this tutorial. I enjoyed this vedio.

[@ExcelForFreelancers]

For sure, you are very welcome Sonjoy

[@andrewmoss6449]

Really innovative method for filtering data! Thanks for sharing, Randy.

[@ExcelForFreelancers]

You are very welcome. Happy to share. Thanks for your comment.

[@garethmorrall1047]

Hi, thanks for sharing so useful! I've subscribed. Is this workbook available for download?

[@ExcelForFreelancers]

Hi and thanks so much. You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

[@AlexVideoProductions]

Excellent tutorial. I have learned a lot of things today. Thank You.

[@ExcelForFreelancers]

Thank you very much. I do appreciate that.

[@asimali5820]

Excellent and Thank you for sharing this Idea....

[@ExcelForFreelancers]

For sure, you are very welcome Asim

[@HABRO-Realestate]

Sir i love your channel. Kindly make video on google sheet. We have multiple user editor or viewer issues. If you can help us in that. Thanks and best regards

[@ExcelForFreelancers]

Hi and thanks so much. My channel focuses on Excel-based applications. I do have some videos that sync with Google sheets. Thank you for your Likes, Shares & Comments. It really helps.

[@moesadr3342]

Would this work if we have several worksheets ( tables) with different data, like Customers, Invoices, Invoice Items,......... Do we have to create an individual Filtering Modules for each sheet/table? How to differentiate/name them? Please advise.

[@ExcelForFreelancers]

Hi and thanks for your comment Moe, The best way to do this is to hide the original database for each sheet. Then create a new 'List' Sheet for each database. You can then filter & sort these sheets however you want. So you would have a separate sheet for Customer List, Invoice List, etc.

[@mumbaitiger]

Awesome tutorial

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@norulzanamohamedsamuri1364]

Hi Mr Randy. What do you think about setting application.enableevents to false instead of setting true or false to prevent the worksheet event to trigger when changes is made to certain cells?

[@ExcelForFreelancers]

Hi and thanks. Yes that works fine as well, however sometimes I want to know if its loading or not for other reasons so the True/False option can help with that. I am using Enable/Disable Events a lot in our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries

[@cecilm3720]

Great video. How would I have to edit the VBA code to accept a search for phone numbers? Thank you.

[@ExcelForFreelancers]

Phone #'s should be treated as a text file so make sure that all the field formats are either General or Text and also make sure to add the "*" character before and after the search text through vba. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@cecilm3720]

Excel For Freelancers Much appreciated. Thank you.

[@dioncadiz]

This is exactly what I need thank you very much for this!!

[@ExcelForFreelancers]

For sure, you are very welcome Dion. I am glad I could help.

[@devramharak7934]

I enjoyed this video and ever since i watched i learnt.Thank you for sharing!

[@ExcelForFreelancers]

Thanks a lot Dev, I am really glad you liked it.

[@ulquiorra3504]

A million thanks for this excellent tutorial. I kindly want to ask, How do you clear the search field upon clicking? I always had to delete the "Enter the name" before I can type in what I intend to search. How do set the search field in such a way that when the user intends to type into it, the default text( i.e "Enter the name) clears automatically without having to delete the default text manually?

[@ExcelForFreelancers]

Hi and thanks so much. We can have VBA do the clearing with a Selection change event, something like if Target.value = "Enter Name" then Target.clearcontents Something like that. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@sanghvidhaval]

Hi, thank you for making and sharing such great video...I am new to learning VBA and would like to know the changes that i need to make if I have to filter the zip code (any data that only has numerical value) in this file

[@ExcelForFreelancers]

Hi Dhaval, thanks for your comment. Numerical values can work on an exact match if you remove the "*" both before and after. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@johnjohnjman]

@@ExcelForFreelancers Is there a way to find auto-filter for non-exact match?

[@kennethsim7097]

Hi Sir Thank you so much for your tutorial, it help me so much in my work. Your knowledge on vba is extraordinary. I got a question on the clear filter, when i try to clear the filter on my worksheet, it only clear the value entered in the input column .. but the clear filter function does't return the data/row to usual.

[@ExcelForFreelancers]

HI i am really glad you like the tutorials. You will want to first make sure that you are running this filter NOT on your original data. This way when you want to clear the filter, you just have to clear the table below and bring back your original data (probably from another sheet) and copy it into the table. The key is that what the user sees here in this filtered table is not the original data table.

[@HarishKumar-rv2kz]

Thank you sir for sharing the worksheet and it's also working well. I have only one question, there is any code/command to filter numeric value ?

[@ExcelForFreelancers]

There are many ways to filter a numeric value. You can first add in data validation for the cell in which you are adding in the criteria. You may also want to run an isnumeric formula to check. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@erasmusdraze604]

Sir thanks for this productive video, it's really helping me. But one challenge I get is when I sort the table based on particular column the filter fields move into the data body. eg. Content of Row 5 is displace to another row

[@ExcelForFreelancers]

HI Erasmus, thanks so much for your message. If your filtering headers are getting caught in the sort then you would want to change the code for one row down (So row 5 instead of row 6) You may have to adjust your other code as well. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@rolandocardoso9119]

Randy I need your help can you let me know how to filter using numbers for this worksheet I was reading some of the comments and I know they are old but some other people had the same issues if you can just help us out.

[@ExcelForFreelancers]

Hi Roland, you will want to make sure to format all columns as numbers, and make sure you do not add an asterisk before or after the numbers, so they are treated as numbers, not strings. I hope this helps and thanks so much.

[@suraksha7841]

Thank you so much for sharing your knowledge. Learned very much and have also apply it on my table. I have a problem with filtering the colum on account no (numbers). Is there a solution for? Thanks in advance.

[@ExcelForFreelancers]

HI thanks for your comment and glad you liked the video. I have created a Facebook group with 4700 Excel Exerts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our Facebook group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.

[@mhmmustha]

Very good explanation and useful video, big thanks.

[@ExcelForFreelancers]

Thanks so much. I am really glad you enjoyed it.

[@pandharinathjoshi6565]

Sir realy great concept Can we use same method to other filter also like … Location filter, City like

[@ExcelForFreelancers]

HI and thanks yes certainly you can use this with multiple filters at the same time. I hope this helps and thanks so much.

[@pandharinathjoshi6565]

Sir really your videos or mind-blowing, but I dont know VBA code… your concept was always great…. I never miss your videos sir Sir, if possible do one video for Spare parts Stock like Stock List, Purchase, Sale and Graph sir

[@ExcelForFreelancers]

Hi and thanks so much I have that for Inventory here: kzbin.info/www/bejne/npLKeqiLhal2p5I I hope this helps and thanks so much.

[@pandharinathjoshi6565]

@@ExcelForFreelancers Sir How can I insert Mobile no. Filter and Invoice no. .. bcoz u told 3 text format and 2 date format like Dim as string and date… I dont no the VBA code sir Sir if possible need insert 2 to 3 column and VBA for filtering sir 1. invoice No. 2. Mobile No. 3. Bill No Its very help ful me sir Need code updation sir …. Its request sir I am very happy this video sir

[@pandharinathjoshi6565]

Sir after download this sheet from date and to date are not working sir…

[@muhammadmazhar7805]

thank you freelancer, is there any help forum to solve the issues regarding vba-excel , so i can send my project to get solution Way of interpret is very very good in your video..

[@ExcelForFreelancers]

Hi Muhammad, thanks for your comment. Please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@rajumasih234]

Sir really wonderful teaching gr8 sir love you

[@ExcelForFreelancers]

Thanks so much, i do appreciate that.

[@oguzturkyilmaz543]

Thank You Very Much

[@ExcelForFreelancers]

You are welcome

[@romanoopdenkelder6843]

Good evening, thank you for you tutorial,this helped a lot. Got a small question for you if I may. When you filter or clear the sheet you end up with a selection of what you filter of clear. Is it possible not see the selection? Now I have to click somewhere to unselect it. Sound basically simple I guess, but how do I do this?

[@ExcelForFreelancers]

Hi thanks for your comment. You can select any other cell in VBA to clear this such as Sheet1.Range("A1").Select I hope this helps and thanks so much.

[@tsokoolet]

Hello there! hoping you can create this kind of filter using ms office script :) this is very helpful!!! thank youu!

[@ExcelForFreelancers]

Hi and thanks so much. I will do my best for training in the future. Thank you for your Likes, Shares & Comments. It really helps.

[@jagjeetsachdeva5829]

Appreciate your work! I have a question: After searching the text, the macro is selecting the whole row. How can I select only 1 cell? Thanks

[@ExcelForFreelancers]

Hi and thanks very much, you can select a single cell using something like this Sheet1.Range("A1").select

[@jagjeetsachdeva5829]

@@ExcelForFreelancers Thanks for your reply. I used this: Range("J7:J" & LastRow).Select and it worked. Cheers!

[@ExcelForFreelancers]

Thats great to hear. Very well done.

[@yuslanld7956]

Excellent tutoria

[@ExcelForFreelancers]

Thank you very much. I do appreciate that.

[@andreshidalgo6663]

Great vídeo! Thanks for sharing!!

[@ExcelForFreelancers]

For sure, you are very welcome. I just uploaded a new one on filters thats different: kzbin.info/www/bejne/oZq0ZpSVnq-ImbM

[@mohamedhisham2811]

Thank you so much, it's a great video. Thank you for sharing I have one question. Can we make an auto filter with drop down list ? I hope to find an answer for my question Best regards

[@ExcelForFreelancers]

Hi Mohamed, and thanks for your comment. Yes you can use data validation as well with this. Instead of a free text field, just use your filter field with data validation list, then it becomes a drop down list. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@mohamedhisham2811]

@@ExcelForFreelancers very good ....... thanks for reply. I will try that . And Thanks a lot again. Do your best excel for freelancers

[@SuperWorld007]

awesome video. I just want to know that I want to use this filter in Excel in moible but mobile excel does not support VBA. So is there any other filter which i can use in mobile to search data regarding a customer such as mobile number, address etc.

[@ExcelForFreelancers]

Hi Excel is not very powerful in mobile so maybe you would want to use Google sheets when it comes to mobile (because of the lack of VBA in Excel in mobile)

[@chuckhamdan1283]

Thank you for the clarification.

[@ExcelForFreelancers]

For sure Chuck, no worries.

[@davidhudson2497]

Thank you this is very useful, I have adjusted it to show a list of my movies. I have one problem, I want to protect the work sheet so the data can't be altered but when I protect it I get Error: Selection.AutoFilter . It works perfect until I protect the sheet. Been scratching my head for days..

[@ExcelForFreelancers]

Hi and thanks for your comment, When protecting your sheet you can select the 'Use Autofilter' option which will allow users to use that. Also through the vba code you can add the xlUserInterfaceOnly command which will allow VBA to make changes that users cannot. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@asifmujthaba1713]

Great tutorial! But I have a doubt, whether we can apply this technique on a proper 'Table'?

[@ExcelForFreelancers]

Hi and thanks you can apply this on any table at all, or just use a range. both should work fine. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@asifmujthaba1713]

@@ExcelForFreelancers Thanks for your prompt response

[@asifmujthaba1713]

@@ExcelForFreelancers I have created an advance filter macro for same kind of application and it wotks well, but the issue is any row with a blank cell (any of the criteria) is not getting filtered. Can you please help me sort it out?

[@ExcelForFreelancers]

HI Asif, can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.

[@gokharol]

Is it possible to filter data by one column topic OR the other? I mean, there are times I don't know whether a piece of data appear in column F or G, so can I set the code to look for it in either one but not BOTH altogether? So the table returns me either rows with said data in column F, but also rows with said data in column G?

[@ExcelForFreelancers]

Hi you can use Advanced filters in VBA to check for both results, one at a time and then post all of the results. I will try to make a video on this within the next few months, however please feel free to ask this question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel we have 23,000 developers who would love to help you with this.

[@chuckhamdan1283]

Excellent tips regarding the flashing reaction. I have one question in regards to the macro "Tablefilt" how come the "If" is not expecting an "end If"? Am I missing something?

[@chuckhamdan1283]

I found the reason. When using the If in one line statement then no need for the end If. Everyday one learn something new. :)

[@ExcelForFreelancers]

Chuck, not only you, but I am learning every day as well. I think I have learned more in Excel this last year while teaching it than I did 5 years before. We are ALL students, so I am learning right along with you. The idea is if you want just 1 thing to happen after an IF, then the End If is not required, however if you want multiple things to happen after an If then you will want to enclose them with an End If. I hope this helps.

[@BharatKumar-fh7ei]

In Excel, How to filter data by using created searchable drop-down, and filtered name to be reflected on header. Or any other options?

[@ExcelForFreelancers]

Hi Bharat, you can add a data validation in your filter along with a auto-complete to help users. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@jamalhasanzakarneh9837]

Thank you very much for this very helpful tutorial. I want to know how to develop this more. Suppose I want to filter by "Name" column by entering more than one word(2 words or more), how can I do this

[@ExcelForFreelancers]

HI Jamal, thanks for the great question. Yes its possible using OR in advanced filters. First you would have to separate the two words in VBA. Once separated Using the same Criteria in different columns in the Advanced filter will provide the OR function. You can see my training on Advanced filters to see how the OR would work here: kzbin.info/www/bejne/j6amo3iNipeHo5I

[@jamalhasanzakarneh9837]

@@ExcelForFreelancers what I want is to get the cells in the "Name" column that contains the two words (or more). So I guess we need AND not OR what do you think. If yes how it can be done?

[@ExcelForFreelancers]

Please watch the video in the link above as I explain both AND and OR functions. Thank you.

[@jamalhasanzakarneh9837]

@@ExcelForFreelancers Than you

[@jaafarjazaerli1344]

I'm new into VBA and starting from scratch beginning with your first videos and I would like to thank you for these videos. when I applied this tutorial step by step, the macro didn't show any error but the filter hided the whole results in the table and didn't show any result (when trying the tutorial excel file that i downloaded it also didn't show any result). I tried mm/dd/yyyy and dd/mm/yyyy formats with no success, any idea what might went wrong?!

[@ExcelForFreelancers]

Hi and thanks for your comment. When it comes to using dates in criteria its better to link to the source (and not have VBA add the criteria) The date should not be formatted as a date and should be in number format. So something like=C5 (so it would appear like 45100 for today's date. or something like +">="&C5 so it would appear >=45100 I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@sharicowan5884]

Hi Randy, Thanks so much for all the examples you have online. I don't know any VBA, but have been able to put quite an elaborate file together for work. As usual, I've modified your example here. I have two criteria for my filter to be empty...If .Range("A8").Value = "J" or "A" Then RName = Empty Else: RName = .Range("A8").Value 'Rep Name . My question is, how do I enter the J and A so it reads both? Thanks so much.

[@ExcelForFreelancers]

Hi sharing i am glad you like the videos. For using Or within the code you can write If .Range("A8").value = "J" or .Range("A8").value = "A" Then RName = Empty Else: RName = .Range("A8").value I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@sharicowan5884]

@@ExcelForFreelancers Thank you so much. I'll join the FB group too.

[@khadijanalghat6]

Hi Thanks for sharing knowledge. I have tried your VBA for my data. While everything is working fine, date filters are not working. I am working on an dd/mm/yy format in my excel file. Does it make any difference? Can you please help?

[@ExcelForFreelancers]

Hi and thanks very much. When it comes to date filters, use a 'General' format in the criteria and not any other formats. This should filter the date properly. You an also use a formula in your criteria directly to the source of the date. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@khadijanalghat6]

@@ExcelForFreelancers Thanks a lot for the prompt response.

[@francescovilla2105]

Very helpful, thank you. In some cases of I don't clear the filter before I change the values, it applies the filter to the header and it flips the input field with the header. Any idea why?

[@ExcelForFreelancers]

Hi Francesco, It is important to clear both the Criteria and Results before adding new criteria then running the advanced filter. Also you should often Delete the criteria before a new advanced filter (If you run an advanced filter with no criteria, in other words you just want unique lists. Excel 'remembers' the old criteria, so its important to delete the named range "Criteria" before applying a new Advanced filter. This can be done via VBA. You can find some examples of how i Delete this in this video here: kzbin.info/www/bejne/oZq0ZpSVnq-ImbM

[@mansurahmad2699]

I liked so much your tutorials

[@ExcelForFreelancers]

Thank's so much. I appreciate that.

[@gabrielsebastianrodriguez5946]

Hi! I did you a consult about a search/filter box in another video and here I found just what I wanted!!! But I applied it to my Contact Manager spreadsheet, and now some of the original functions don't work! The info of the contacts is not loaded into the respective fields when I click on one, and the color bar doesn't shows up either. Help me! What did I screw up?

[@ExcelForFreelancers]

Hi Gabriel, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@stevennye5075]

very useful!

[@ExcelForFreelancers]

Thanks so much Steven

[@concisereadings7599]

Excellent work , but I think before watching your videos i need to learn atleast basics of vba, Should i go with that free course of yours or any you tube video for that????

[@ExcelForFreelancers]

HI and thanks. Yes it is a good idea to have some VBA fundamentals first. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

[@JourneyGlimpse_sajeda]

Hi Can you suggest me any video by which after filtering data, filter data can be extracted to other place and Depending on the filter information, everytime time the extract data will be changed. Wishing for your suggestion

[@ExcelForFreelancers]

Hi Sajeda, sure this Advanced Filter video here explains that process: kzbin.info/www/bejne/oZq0ZpSVnq-ImbM

[@TheTramos00]

Works better adding a change event in the fields, added like an activex control, so that the data is filtered as it is written and we don't have to press enter. Just a suggestion. Thanks.

[@ExcelForFreelancers]

Hi thanks that is a good suggestion as well, however Active X does not always work well with Mac's and with large tables adding so many controls may be a bit slow however on a smaller table it's a very nice idea. Thanks for your suggestion.

[@kytan13]

So if i would want to filter without pressing enter, how would this be done? Excel For Freelancers, Thank you for all the videos that help me very much.

[@TheTramos00]

@@kytan13 I can send you the VBA code. It is simple. Send me your email

[@chuckhamdan1283]

Hi Randi, I was wondering if you could list in your web site the list of the Excel workbook you created in order to download easily as each time one wishes to download a workbook one has to go and re-enter the user id and password. This is just a suggestion. Regards, Chuck

[@ExcelForFreelancers]

I agree with you, Chuck, it's kind of a pain, so I am developing a single workbook library with my most popular applications all in one. This should be a really great and very fairly priced application so you can have a complete VBA Application Library at your fingertips.

[@mdsaiful6294]

Nice video 😊😊

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Saiful

[@KarolKarbownik]

hi - problem here with private sub in line "if not intersect ...." - saying compile error - argument not optional - have anybody got this issue - all code is working up till point - thanks for any suggestions.

[@ExcelForFreelancers]

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@davidzimmerman3108]

Working great! One question is there a way to Dim a column as Phone number?

[@ExcelForFreelancers]

David Zimmerman Hi I'm glad it's working well. I would Dim a phone number as text. Since you wouldn't be performing any numerical functions with it.

[@TheSilverSoulDriver]

Hi. I know I'm late to the party, i just want to check, in the last section of the video. Do you still hit enter to bring up the search results? I know it's meant to be automatic but even with the coding mine does not bring up the results by itself. My data is grouped. Would this influence this function?

[@ExcelForFreelancers]

Hi and thanks make sure the change event is being activated and also feel free to step through the code using F8 to check for exits to the code. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@gokharol]

This is great! But how can I make it more dynamic by not having to press enter and getting data to show up just as I type?

[@ExcelForFreelancers]

Hi you would want to use an ActiveX component instead of a cell-based component if you want to filter results based on what you type. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@rkraman09]

Same query here

[@cnsane]

Thanks, its very helpful. I do have a problem. I changed the name column into numbers and the filter wouldnt work, can you please help me in making the autofilter to work with numbers? Thanks,

[@ExcelForFreelancers]

Hi thanks for your comment and I am glad you find it helpful. You will want to make sure your criteria is using the same header name as your original data within the advanced filters. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@cnsane]

Actually, I figured it out. for criteria1, instead of using wildcard, which is for text, I changed it to equal to the name of the column

[@ExcelForFreelancers]

That is great to hear. I am glad you have figured it out.

[@simuislam5752]

Nice video

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Islam

[@rolandocardoso9119]

has anyone done this worksheet filtering by numbers that can share how it was done I've try acouple suggestions but can't get it to work

[@ExcelForFreelancers]

HI and thanks. When filtering by numbers make sure to remove the asterisk before and after the number and also make sure your columns are formatting as numbers I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@chairulumam6412]

halo i have some question there's an error while i compile " argument not optional " it happend when i change or press enter to filter, is there any help for that?

[@ExcelForFreelancers]

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.

[@twoheadlines]

Hi Randy. Really enjoying the learning development and experiences gained from your tutorials and use of downloaded workbooks. Unfortunately I have hit a snag with the use of "Selection.Autofilter". When I run the code, I am immediately returning the error, sub or function not defined, high lighting "Auotfilter" . Here is a section of the relevant code which I hope will be enough for your to help identify where I might have gone wrong: Selection.AutoFilter With .Range("C5:X" & lastrow) AutoFilter field = 4, Criteria1:=">=" & TDate, Operator:=xlAnd, Criteria2:="=" & BDate, Operator:=xlAnd, Criteria2:="=" & SPlan, Operator:=xlAnd, Criteria2:="=" & RDate, Operator:=xlAnd, Criteria2:="=" & NextAss, Operator:=xlAnd, Criteria2:="

[@ExcelForFreelancers]

Hello Stephen, Try to clear the filter before running a new filter, and also check your protection settings. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@noureddinegp770]

I would like to learn VBA fundamentals is there any good book or tutorial for this

[@ExcelForFreelancers]

HI and thanks I also got your email with that question and responded: I have some great courses on my partners page to learn the fundamentals here: www.excelforfreelancers.com/partner-courses/ Thanks so much.

[@dawidvos67]

Hi I am very new to Excel VBA. I like your Table Header Filter and it works well for me. I, however, have a question. I have a column (ID No/Social Security Number). column. How can I modify the code so that I can also search on a field with numbers? Thanx

[@ExcelForFreelancers]

Hi you would want to make sure that the formats and the variables are set to numbers so that it ensures excel uses #'s. Also make sure to remove the "*" from before and after the search filter variable. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question with code screenshots here:bit.ly/groupexcel

[@dawidvos67]

Thanx very much for the fast reply. I posted on the group as you suggested.

[@ExcelForFreelancers]

Great Dawid, I hope we were able to help there.

[@rolandocardoso9119]

sorry I was wondering how do you set them to numbers through this worksheet without messing up the codes

[@luckybhatti952]

how to create application in excel i will make an entry in the cash book, this entry will be automatically updated in the lager

[@ExcelForFreelancers]

Hi and thank you can search my channel for "General Ledger" I have two videos on this. I hope this helps and thanks so much.

[@utekavvadias1867]

Congratulation, a great video. I am quite new at VBA and need your support. How can I search also for names with Greek characters?

[@ExcelForFreelancers]

HI Ute, thanks for your message. While I don't personally have experience with Greek characters, make sure you change the fonts in the VBA Editor and your computer as well (You may need to restart after this) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@ZafarWaheed]

Awesome, as always.

[@ExcelForFreelancers]

Thank you very much :)

[@rhondagauger3273]

Love the program. I have 2 search fields A5 and C5, ContName (dim as String) assigned to A5 and Facility (dim as string) assigned to C5. I get no errors, however only field A5 (Field 1, Cell A5 ) searches correctly. C5 (Field 3 Cell C5) continually searches correctly but displays no data. Is the following code correct? If ContName Empty Then .AutoFilter Field:=1, Criteria1:="=*" & ContName & "*" If Facility Empty Then .AutoFilter Field:=3, Criteria1:="=*" & Facility & "*"

[@ExcelForFreelancers]

Hi Rhonda, Thanks for your comment. I would use F8 to step through the code line by line. To make sure the values are correct. Also make sure the values are also formatted as text in your table. If it still does not work, we can probably fix this for you. Please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@ScottMattes]

Instead of putting the Clear Filter with True/False in a cell on the spreadsheet, could you have also just defined a variable above the first Sub in the module?

[@ExcelForFreelancers]

HI Scott. thanks for your comment. We want to make sure we differentiate between two types of worksheet changes. One in which the user is making a change when they want to filter, and the other change by VBA when clearing filters. Setting a True/Values value in a cell helps us differentiate between these to changes when triggering Worksheet_Change events. There may be several ways to accomplish this. Thanks for the great questions.

[@fevyagustin2383]

Hello sir than you for this, I have tried it and it works.. only problem is when i tried typing a name not included in the selection and did it twice, the other rows automatically hides and the filter moves up unless i again clear the selection, it then goes back to normal not hiding the other rows. pls help

[@ExcelForFreelancers]

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@chethanpadmanabha3548]

First of all, Thank you so much for the video.. In above video suppose we type 'John' and it filters out and shows the result,. In the filtered out result can we update/manipulate data such as changing contact info so that it gets updated. Is it possible to do so?? If yes please let us know. Thanks. 😊

[@RandyAustin]

HI I am glad you like the video. In the workbook above, this sample you can update easily by changing the data at any time. You can then re-run the filter again if you like. Make sure you download the free workbook (link in the description) and try it out for yourself.

[@chethanpadmanabha3548]

I tried, I works. Thank you so much.

[@ExcelForFreelancers]

For sure, you are very welcome

[@rolandocardoso9119]

can some help adding a number filter for this worksheet I got it work for address and name but not for number

[@ExcelForFreelancers]

Hi Rolando, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@eujiecostales27]

Hi Sir, how to filter if the field is double (e.g. "1.001", "3.004") using autofilter. I would like to ask the script for that. Thank you

[@ExcelForFreelancers]

HI and thanks this tutorial teaches you how to do that via Advanced filter in which you can filter in place or another location. you will want to specify filters based on a number or text and then make sure the fields are formatted properly. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@Mubin360]

Realy exceptional. Thank you. Please update the download link.

[@ExcelForFreelancers]

Hi Thanks so much for your comment. I did just make an update to the Facebook Messenger link which should be working well for downloading the workbooks. (Email link for download should also be working) Please let me know if you have any questions.

[@davenrmt]

Hello, Firstly, thank you for producing these videos. I am learning a lot and it is supplementing my further readings on VBA/Excel. This is a personal hobby and not my day job. My question: I love the filter in the header and learned quickly that the data can't actually be in a Table w/header (unless the data is in a table without the headers and you created the headers separately?) Anyways, I have a column of data that is conditionally formatted. The header is "Complete" with a simple Y or N to trigger the CF. IF yes, nothing happens; however, if N then the square fills with a light red. Very basic. I have created a filter for this column and it works for Y (unformatted) but not for the N (which has the fill/format). I would like the filter to also work for the "N". Do you have any suggestions without removing my Conditional Formatting? Thank you again for your awesome Videos! Dave

[@ExcelForFreelancers]

Hi that is great to hear, thanks so much for your feedback. I am glad you are enjoying these videos.

[@davenrmt]

Excel For Freelancers what do you think about my problem? Any solutions come to mind quickly? Also, I don’t have Facebook.

[@ExcelForFreelancers]

Hi Dave, sorry i missed you original question. I am not sure I understand the issue entirely. If you have entered both Y and N as text in the table, the filter should work properly and you should also be able to assign regular or conditional formatting to either of these without issue. Perhaps you can upload the application or screenshots in our Excel For Freelancers Facebook Group so we can take a closer look at it. I know we will find a solution for you: bit.ly/groupexcel

[@johnjohnjman]

I have a problem with clearing the autofilter. I managed to get the columns to display the default texts after running the "subclearfilt" macro but the filtered columns doesn't clear (i.e. The columns that were filtered remains hidden). How do I fix that?

[@ExcelForFreelancers]

Hi its hard to know the exact code issue without seeing it. Please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@wayanuding1314]

It's possible to Create Dynamic Excel Filter - Extract data as you type

[@ExcelForFreelancers]

Hi it may be able to be done with an activex or form control field as those types of boxes have events on change, while cells have macros that run only when a user exits a cell. I believe their are some videos on KZbin describing this so a quick search may be helpful. Thanks very much

[@johnjohnjman]

I am new to VBA, one thing I'm curious is how does the Dim statement recognize the Name field as ContName and Address as ContAdd. Like can you just simply key in a name in the module form by keying in Dim followed by whatever name you want and "As String" or "As Date". I'm not sure how does it all works. Also, I'm creating a similar spreadsheet but I have more fields (some are numbers and some are texts). Do I need to make more Dim statement s and write in the module = "Dim (whatever name I want to refer to another field I want). As String"?

[@ExcelForFreelancers]

Hi it depends how you want the variable used. For example if you want to use a variable in math or find the maximum you would want to dim it as long or double (which are numbers) and if you want to format a variable as a date then you would want to Dim it as a date. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@marcusobrien1026]

Hi, Could you please do a video on how to create a "SAVE DATA" button. Would like two things to happen when the button is pressed: 1 the data is save in the same workbook (in let say sheet 2) under the respective heading.and you get a message saying"DATA SAVED" and all all cells that have entire in it are cleared. Some cells having drop down. Would be a great help on this work book I am currently working on. Can send it to you and discuss more on it. Thanks, Regards, Marcus

[@marcusobrien1026]

Just one more thing, I want it to save the data no matter how many times the same data is typed. Example if I have a customer who comes In X number of times want X number of times the data saved.

[@ExcelForFreelancers]

Hi Marcus, thanks very much. I have been covering a lot of that in our Employee Manager series which I think you will find really helpful. There are tons of features here which will help you a lot to learn on Saving Data and all of the options that go with it. Its a multi-part series, so far 3 parts, but a new part comes out every Tuesday. This is what I have so far: Part 1: kzbin.info/www/bejne/n6rVaop_rt2fgMU Part 2: kzbin.info/www/bejne/opPEZq1rh9Gtrqs Part 3: kzbin.info/www/bejne/a4a3fZWfabxsl9k I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel