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

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

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

RichCovo wrote:
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
Contextures
http://www.contextures.com/tiptech.html