I've seen previous posts on this, but most are over 2 years old. I'm
operating 2007 but routinely save in 2003 for other users. If this is a 2007
solution only, that works for me:

Is it possible to filter a range using either a partial or exact match from
a remote cell? Value retained in cell A1 ( that can change) with the
filtered area being A10:Z100 ( or something like that).

It is not very productive to constantly use the drop downs and search or use
the "contains" function within the filter.

Any help would be greatly appreciated !!