When I use an Advanced Filter in Excel, is there any way to set it up so
that, once the filter is defined, the filtered list changes as soon as I
change the criteria?

I want to automate the production of multiple lists depending on the
user's input, with transfers between multiple worksheets etc, and I
cannot ask the user to go through various worksheets and click through
Data--Filter--Advanced Filter--OK everywhere.

I could ask the user to click once somewhere. I suppose I have to write
a macro that will go through all the worksheets and execute
Data--Filter--Advanced Filet--OK everywhere? Somehow I feel there must
be a better way ...

Newt