Did you know that Excel produces automatic name ranges when you use advanced filter?

The moment you specify a criteria range and use Copy To: , Excel creates name ranges called: CRITERIA and EXTRACT.

So after you have defined the criteria and the copy to location once, you can simply type the name ranges into the dialog and it works from them.

(Please remember that the names are not dynamic though. If your criteria range increases or decreases, you need to respecify the range manually, else the wrong criteria will be implimented!)