Hello Excel Guru,
I am not very skilled with VBA in Excel.

I have a hige sheet and I would like to filter it. At moment I am
using the Advanced filter but it is not very "confortable": one of
filtering criteria is matching some strings in column "description".
So, if I have to find only one string (e.g I am looking for
"connection" string )I set the "criteria range" as

Description
*connection*

If I want to filter cells that have at some time the strings
"connection" and "battery" I have to add a column in the criteria
range:

Description Description
*connection* *battery*

so I have to change the criteria range all the time.

Some matter with other columns where I should find if the operator is
"kriss" or "andy".

I was wondering if there is a chance to use a query which I can build
programmatically. I read something regarding the chance to load the
"ODBC" plug-in which should allow me to connect to a database. Does it
work for filtering excel sheet itself ?

Thanks,
Massimo