You can use the Worksheet_Change event to update the filtered lists.
There are some examples on my web site:

http://www.contextures.com/excelfiles.html

Under the Filters heading, look at 'Product List by Category'

ms newt wrote:
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 ...


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html