VBA Autofitler multiple cell/ fields partial str match, treat blank fields as any results

**sdl2** · 11-12-2014, 09:12 PM

Hi All,
I have some code below. Right now a message box comes up and I type in a search term *3RD* for example.

Firstly, how can I get rid of typing *term* the asterisks...
Secondly instead of a message box I just want to use cells that I type into. But if the cell is blank, I want it to be treated so that it returns any result. For example if a record is field1=12 field1=6c and I enter into cell1:1 and nothing in cell2, that match should return. I have attached a file.
WildCardFilter.xlsb

Please Login or Register  to view this content.

**davesexcel** · 11-15-2014, 05:54 PM

Ha! that's a worksheet and code I made several years ago.
The copy code comes from Tom Ogilvy, that I got from Contextures web page.

Anyway,
You can use wildcards for filtering like this.

Please Login or Register  to view this content.

What cells did you want to use as the criteria to filter for?
It looks like you have about 12 criteria cells but you don't have that many columns.

I will just use two criteria so you will get an idea.

Please Login or Register  to view this content.

**sdl2** · 11-19-2014, 08:20 PM

Hi Dave,
I have written code that uses the same wild card, however, I am having trouble getting a return from two types of data, firstly numbers and secondly dates. I search for *6* in a list of 0.651 6.02 106.2 and the return is 0 results. What is causing this and how can I fix it. Second *11/9* from 11/9/2013 or *2014* from 11/9/2014 returns no results. For example I want to search column 1 for Criteria A=392 I get no results, i did change this...

Please Login or Register  to view this content.

Any ideas?

**davesexcel** · 11-20-2014, 07:28 AM

are we both talking about the same workbook?

**sdl2** · 11-21-2014, 09:25 PM

Hi Dave,
Yes it is the same workbook, my workbook has much more data. But if you search field 1 for 6 or the date field ex. 2014, no results are returned. I think this is because the data type is numerical and date. How can I convert the column to text and search it and then back to numerical and date? Is this the appropriate way to handle these data types?

**davesexcel** · 11-21-2014, 10:00 PM

maybe post the problem workbook

VBA Autofitler multiple cell/ fields partial str match, treat blank fields as any results

LinkBack

Thread Tools

Rate This Thread

Display

VBA Autofitler multiple cell/ fields partial str match, treat blank fields as any results

Re: VBA Autofitler multiple cell/ fields partial str match, treat blank fields as any resu

Re: VBA Autofitler multiple cell/ fields partial str match, treat blank fields as any resu

Re: VBA Autofitler multiple cell/ fields partial str match, treat blank fields as any resu

Re: VBA Autofitler multiple cell/ fields partial str match, treat blank fields as any resu

Re: VBA Autofitler multiple cell/ fields partial str match, treat blank fields as any resu

Thread Information

Users Browsing this Thread

Similar Threads

Combining Partial Name Fields

Search multiple fields for text when all but 1 are blank, and display that cell's text

Excel 2007 : Join multiple field and ignore blank/false fields

Excel 2007 : Excel 2007 - Search fields and multiple values in results

match multiple fields in records

Bookmarks

Bookmarks

Posting Permissions