AutoFilter using wildcards

[kirana2014]

Dear all,

I have a list of 100+ customer number and want to search it with variables such as find all numbers where number is "268", or is "12" etc

The solution is in Excel’s custom AutoFilter and using wildcards in the criteria.

I use below code but not working

Please Login or Register  to view this content.

example i would like to search all customer with number :
268 the result must be 352689 and 322687
12 the result must be : 100123 112345 287129


customer number
100123
112345
352689
354278
287129
322687

Thank you in advance for your help and support
Kirana

[AB33]

This thread will answer your request.

https://www.excelforum.com/excel-pro...ank-value.html

[kirana2014]

Dear AB33,

Please help see attachement


Thanks
Kirana

[Alf]

In order to use wildcards searching for numbers with autofilter the range where the numbers are must be formatted as text and the Criteria should look like this where i is a part of the number.

Please Login or Register  to view this content.

So if you had a range with headings in A1 and values in range A2:A7 and this range was formatted as text a macro like this could be used for filtering with wildcards.

Please Login or Register  to view this content.

Alf

[Alf]

Read you PM but as your uploaded file is rater difficult to work with for me trying to test how to implement a number sorting macro I'll give it a pass.

Not sure I understand. you problem i.e. you wish to enter part of a customer ID and then you got a range of customer where ID contains this part but how do you go from there?

Will you from a group of say 4 customer select one or will you select all of them? Depending on the number of customers have you considered using a "drop-down" list instead of going for an autofilter?

I've uploaded a small file where you can find numbers that contains a given part of a number. There are 3 macros. Macro "FindNumber" and "FindNumberAddress" works with numbers.
Macro "FindNumber" will hide the rows that don't meet the criteria i.e. (the search part). To reset data after using this macro run "UnhideRows"

The macro "FindNumbersAsText" will only work on Sheet("Numbers_As_Text") using autofilter settings. The other two macros will also work on this sheet without any problem but macro "FindNumber" will still hide rows where criteria is not met.

Alf