VBA autofiilter unprecised criterias

Hi all,

Here is a challenge for most of you, I am not even sure it has a solution....

Basically I am trying to filter an area with criterias that always change and I was wondering if there was a way to set up a criteria for all the names starting with "BNP P...."

ActiveSheet.Range("$A$2:$AK$221960").AutoFilter Field:=8, Criteria1:= _
"BNP..."

This would be the equivalent of when you filter and you write what you are looking for where it automatically selects those things that start with the message you have written...

Thank you and hopefully there is a genious out there capable of doing it,

instead of your range, try to put this
and select the cells where you want to run this macro
ActiveSheet.Range(Selection.Address)

???? This does not solve this post.... This solves my other post

Please Login or Register  to view this content.

Currently, the criteria is fixed, i.e. BNP, but you can make it as a dynamic by linking the criteria to a cell, so when that cell changes, the criteria changes too.

This does not solve my problem as it is impossible for me to know the exact criteria because it changes all the time....

Thank you anyway for trying...

Where is the criteria stored?

Basically I am analysing some products that change every week but the code always starts with a similart thing; For example the code starts with "BNP..." and then something different. There istn really a fixed criteria, I just know how it starts...

It the criteria would be anything that starts with "BNP...."
And so on; tell me if I haven't been clear enough

You can add wild card for (Criteria) BNP, but this also assumes the criterion always starts with "B" which is not probably the case.
You may need a different approach.

Not sure what a wild card is and no; the criteria does not always start with B....

Thinking of a different approach, should I try copy and pasting the column that I want to filter in a new column and then play around with the control replace? Do you think that could work? Any other ideas, suggestions?

Thanks for trying mate

May be use input box message to either ask for criteria, or use it to search for a particular word.
A search code would be another option, instead of filtering.
Wild card is "*". You add * as prefix, or suffix to criteria so that it filers all starting or ending with *

Tried the wildcard! It works quite well!

Thank you so much, you saved me an awful amount of work.

I'll mark this as solved and add to your reputation!