Yes, a macro could do the job, but it sounds overly complicated to me. Why not
just use AutoFilter? (not Advanced, just the normal one). It will give you a
drop down arrow in your State cell, you click on it and select CA. It's at least
as easy, if not easier, than typing CA in another cell.

If you're having trouble turning it on, it may be because row 1 is blank. Either
delete row 1, or highlight row 2 when you turn it on.

--
Regards,
Fred


"sjamadok" wrote in message
...
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.