Use input box to make filter choice while providing list of possible filter choices

[GretOgrady]

Hi all - trying to set up a input box that becomes active as soon as
the user opens the workbook. The data primarily contains sales info
with country, region and city tags so I'd like the user to make a
choice upon opening within one of three possible filters (maybe they
just want to look at US or maybe they want to look at Missouri or maybe
they want to look at St. Louis).

I'd like for the user to basically choose from a list for what they
should be filtering on (instead of having to type it as input)

(Actually I wish my users could just get over the mental block of
making their own filter choices without having to set this up as a
macro but we aren't there yet...)

Can anyone offer assistance? Thanks if you are able - Gretchen

 

[Dave Peterson]

You may want to look at Ron de Bruin's EasyFilter.
http://www.rondebruin.nl/easyfilter.htm

Either to use or to glean some ideas.

 

[GretOgrady]

Thanks Dave but I'm not sure this works in my situation - the people
that will be using this are very high up - I won't be able to ask them
to download an add-in of any sort and really need to have it be as
user-friendly as possible - any other ideas?

 

[Dave Peterson]

I really think that they should learn how to use Data|Filter|autofilter.

It's not that difficult and if they learn it for this project, then think of how
many other workbooks could benefit.

Show them how to use the dropdown arrow to select what they want. Toss in how
to use Custom and then show them Data|Filter|Showall to reset all the filters.

I think that's money better spent.

(I bet you don't like this answer, but imagine the enthusiasm you'll see when
those old dogs learn a new trick!)