Hi there,

Is there a way to create a filter that accomplishes the following:

Example Speradsheet
A B
1
2 City State
3 Phoenix AZ
4 Los Angeles CA
5 San Francisco CA

I would like to filter the above data by the state of CA just by typing "CA"
into cell B1 and hitting enter.

I tried playing with advanced filtering, but every time I wish to filter on
a different state, I must go to Data, Filter, Advanced Filter. I could make
a macro to do this part, but was wondering if there is a different kind of
filter I could use.