Dynamic Filtering

[Flintstone]

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?

 

[Don Guillett]

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.

 

[Flintstone]

Thanks for the reply. . . I have arrived at a solution that is not perfect,
but does the job. I discovered that the suject line should have been
"Refresh Filter" instead of "Dynamic Filtering".

I created a control box with a very short macro that refreshes the filtered
data. As a result, the user only has to type in the "search word" and then
click on the Refresh Filter control button. The data is then refiltered to
show the desired results.

Thanks for prodding me along.
Fred