Can i get advanced filter to automatically refresh

[Guest]

I have set up an advanced filter, but don't seem to be able to get it to
automatically recalculate the filter when i change the number i am filtering
for in the criteris range. Is there a way i can get the filter to
automatically refresh when this criteris is changed?

Thanks in advance.

 

[Debra Dalgleish]

You can update the filtered list by using programming. There are
examples here:

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

Under Filters, look for 'FL0001 - Product List by Category'

 

[Harlan Grove]

You can update the filtered list by using programming. There are
examples here:

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

Under Filters, look for 'FL0001 - Product List by Category'

....

You only use a Change event handler. That may be sufficient in this
instance, but it's safer to use a Calculate event handler too, with
the Calculate event handler using a static variable to check for state
changes in specific cells to determine whether it needs to refresh the
filter. Both the Calculate and Change event handlers would call a
common private subprocedure to refresh the filter.