Advance filter or filter to get partial strings

Hi,

i am using code like here:

Please Login or Register  to view this content.

to set up rngToFilter range in one workbook.

Also i i am getting array for criteria to use on second workbook.

In second workbook i have:

Please Login or Register  to view this content.

this is working but only when i have eact match in array.
But goal is to have partial match here.

I tried with "*" & v & "*" but i am gettin error (typeMismatch).

Why? How to filter it?
Best,
Jacek

Here you are,

sorry for delay

Code for sample:

Please Login or Register  to view this content.

If i will use "*" & v & "*" (partial string what is a goal here) i will get error.

Jacek

Thank you jindon. It seems complicated. What if I would have only one column to filter without color criteria? It should work ? I tried this and it didn't work for me maybe I am doing something wrong

1)

Please Login or Register  to view this content.

2) If no need to filter by color, AdvancedFilter can be also applied.

Please Login or Register  to view this content.

Thank you!!

It is working like a charm

Jacek

One more thing to ask,

how can i now set the range from filtered one?

Jacek

AdvancedFilter, you can adjust it to Aurofilter.

Please Login or Register  to view this content.

Thank you so much,

Jacek

Please explain how this is working:

"=sum(countif(a1,{" & x & "}))>0"

In my real data i have result as FALSE but still this is working.
For each variable is checking if there is occurence and it is - advance filter is taking it?

Jacek

The result of the formula is just for the first record.
AdvencedFilter will apply that condition to each row.

Great !! Thank you