I think you will need an advanced filter for that rather than an autofilter. Is it OK to set that up in the file?