Hi sbrimley

No problem to do this
But if this is the only thing you will do with it then you can use Debra's example also.


--
Regards Ron de Bruin
http://www.rondebruin.nl



"sbrimley" wrote in message ...
Thanks I will give it try, I am assuming that if I need to share my excel
file with other co-workers I will need to have the IT staff place it on
everyones PC or on our network. Are there any problems with doing this?

"Ron de Bruin" wrote:

Hi sbrimley

The limit is 2 with Autofilter
You must use AdvancedFilter to do it

My add-in have 5 options
http://www.rondebruin.nl/easyfilter.htm
Maybe you like it



--
Regards Ron de Bruin
http://www.rondebruin.nl



"sbrimley" wrote in message ...
Is it possible to select more than 2 options using custom auto filter?

I have a worksheet filled with contact names and the cities in which they
live and would like the filter results to show 3 or 4 cities at a time. Is
this possible? I have been playing with custom auto filter and so far I am
only able to view two cities at a time. Any suggestions?
Thanks