G
Guest
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
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