I managed to do this on my own :-) from a previous answer to a similar
question.


"Kathrine" wrote:

I'm using advanced filter with several criteria to extract data to a new
destination.
This works fine. I have a macro to run the filter. As of now I run the macro
manually (i.e. by pressing a button) whenever I change the criteria.

However, having the macro run automatically every time I change one of the
criteria cells would be much better - and I'm sure it's possible - I just
don't now how...

Please help anyone..
Thanks