You can goto this site and learn a lot about this
http://www.contextures.com/tiptech.html

or
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Flintstone" wrote in message
...
I have a spreadsheet with a filter using "contains". I want to be able to
update one cell with new "contain" criteria that will automatically filter
the new results.

In a very simple example, I have 100 rows of data in Column B of my
spreadsheet. I have typed "Apples" in cell A1, but now I want to change
cell
A1 to "Grapes" and then only see filtered results with "Grapes" in Column
B.

I have found the formula "=IF(ISNUMBER(SEARCH(A$1,B3)),"Match"," ")" which
is great for identifying which cells in Column B contain the desired
matches,
but how do I get to the next step so that it automatically filters? I
will
have multiple users who will be using this spreadsheet and I do not want
them
to have to filter each time to see their results.

I know that the answer is somewhere in this forum, but I have not been
able
to find it?