Auto Filtering Multi-Fields / Columns

I've researched the Forum and the Web for assistance without success.

Want to Auto Filter Table1 by reviewing several Fields (columns) at the same time.

The workbook has TextBox1 at the top of the sheet for entering the 'Filter/Search Term'.
Type in the filter term and it "auto populates" the row display and narrows down the filtering as each additional
character is entered. If the macro utilizes only one Field/Column for filtering, it functions as expected.

This is the single field macro approach that functions properly :

Please Login or Register  to view this content.

The above macro utilizes a FILTER and a ROW column as part of the Table :

Filter Row.jpg



If more than one Field/Column is stated in the macro, it will not function as needed. Nothing
is returned ... no error messages.

Examples of code (not actual workbooks) on the Web indicate the possibility of doing the following for
multi-fields / columns:

Please Login or Register  to view this content.

No Luck.

I've tried giving each Field/Column it's own macro & TextBox ... no luck.


I would really like to be able to AutoFilter the table (49 columns) by focusing (at a minimum) on any
of 4 - 6 total Fields/Columns. The process must use the TextBox for user ease.

Suggestions ? Thank you.

Perhaps

Please Login or Register  to view this content.

jindon:

Thank you so much for your reply.

Question: How can the macro be edited so it will display all possible 'returns' and narrow those down as each additional character is entered in the TextBox ?

Presently, if a Company Name contains more than one character, all characters need to be entered and match before a return is displayed.
The example project I was using as a pattern provided partial matches as the characters were typed.

[ attached ]

Are you sure about the attachment?

It seems totally different.

jindon:

It is different. But I was trying to implement that code in my workbook.
That code works in my project but only for one column.

I probably missed something but thought I had captured everything there was.
The main difference is the number of columns my workbook is utilizing.

I have not seen anything that specifies a limitation on the number of columns. Is there a limitation ?


humdingaling:

Your code is close however the first field (2) is not capturing all possibilities at first then narrowing down the possibilities. The
other fields work as desired.

Don't understand which file you are talking about.

If it is the first one, just add asterisk after the criteria
i.e

Please Login or Register  to view this content.

jindon:

Added the asterisk.

Please Login or Register  to view this content.

TextBox 1 not returning anything. Other textboxes worked as desired. This is using your macro in Post #2



The attachment I spoke of in Post #6 is attached in Post #3. The code in attachment of Post #3 works in
my workbook but for only one field/column. Couldn't get it to function for multiple columns.

Because the numeric value, you need to add apostrophe like '1, '2, etc. if you need to use wild card.

jindon:

Ok, got that to work. But I'm concerned about the end user.

Tried formatting the column (#2) as Text but that didn't make a difference.

I could add some code to automatically add the apostrophe so the user doesn't have to remember but I wonder
if there is another way of doing this so the apostrophe doesn't need to be used at all ?


Thank you so much for all you help.

It's late here now. Have to get some sleep. I will check in the morning for any additional suggestions ya'all might
have.

Thanks again ! Happy Memorial Day !

You can convert it to text before the loop

Please Login or Register  to view this content.

jindon:

Thank you so much for your efforts. The filtering process is now complete.

You and humdingaling have been an immense help.

Have a great day !