Advanced Filtering VBA based on cell value

[kingofcamden]

Dear all,

I am working on a global email communications report covering 12 markets.
As per the screenshot attached, I would like to filter results based on the cell value in D3 ("Austria") whereas D3 is a drop-down listing all 12 markets in two variants (one is just the market e.g. "Austria" and one is "Austria_Trigger"). Based on what is selected in this drop down, a filter should be applied to all columns from row 14 to 8000 taking the campaign name as a reference (column D).

An example:

• If "Austria" is selected in D3, all results should filter and only show campaigns that contain "Austria" in the campaign name (however, EXCLUDING campaigns that contain "Austria_Trigger").
• If "Austria_Trigger" is selected in D3, all results should filter and only show all campaigns that contain "Austria_Trigger" in the campaign name (EXCLUDING campaigns that contain "Austria" without the _Trigger extension).

Same would apply to the other 11 markets.

Hope this makes sense...

Would this be possible with VBA? How would I need to assign the macro to the drop-down in order to work?

Hope someone can help...would be highly appreciated!

Thanks,
Mat

 

[kingofcamden]

Hi all,

Tried all day to manage and get it to work...no success yet
Hope someone can help...

Many thanks,
Mat