Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Filtering
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Filtering | Excel Worksheet Functions | |||
Automatic filtering and coping result to a seperate sheet | Excel Worksheet Functions | |||
Please help with adding automatic data. | Excel Discussion (Misc queries) | |||
Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
options to update automatic links | Excel Worksheet Functions |