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). Adding another layer of complexity: the sums of the results should only reflect the data of the visible rows once the filter is applied (if I filter manually, the sums include all hidden rows too, which is a problem).
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).
The row displaying the sums for all results should change accordingly and only take data from the visible rows (not the filtered out ones).
Untitled-1.jpg
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
Bookmarks