Thanks JMay for the response. I was hoping not to have to use macros but I
guess I will.

"Mitch4" wrote:

I would like to have a drop down list be used to be able to select the
criteria for the auto filter on another worksheet. Is this possible?