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.
Bookmarks