Automating Advanced Filter

Hi all,

I've managed to find the following macro to automate advanced filter.
It works good but the results are on the same sheet as the data (sheet "data").

Can someone help modify the beklow so that the criteria is on sheet "Result" range A11:G12 and the results are displayed on the same sheet with headers starting A20:G20.

Many thanks

Please Login or Register  to view this content.