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.