Trigger "advanced filter" macro from a different sheet

Hi all, I've been trying to figure out a workaround for this, but I can't seem to find a solution.

I want to use a macro to set an advanced filter that filters data on sheet 1 based on criteria on sheet 2 and pastes it onto sheet 3. Before pasting the filtered data onto sheet 3, I empty the sheet. The macro is triggered by selecting the filter from a drop-down combo box. Now I've got it all set-up and running, but I want to place the combo box on another sheet (sheet 4) for user convenience.

I thought about placing another combo box with identical content on sheet 4 and linking it to the combo box on sheet 1, but I couldn't figure out how to do that.

Here's the code I use:

Please Login or Register  to view this content.

"DB", "EU2_Block45_46_47_FZ04", and "DBF" are defined names. I have 21 Filters and a macro for each of them.

Any help would be highly appreciated! I'm a VBA novice, but if your time is short and you have a solution at hand which you don't want to explain in detail, just drop me the code and I'll figure out how to use it

Nick

I'm not clear where your criteria are, etc

Your code needs to refer to the sheets, something like this

Please Login or Register  to view this content.