Advanced filtering questions

[daxy]

I've been struggling with this one all day. I hope you can help.
I have a set of Raw data which I'd like to filter based on Manager. The Manager is not defined in the Raw Data, only the products he's responsible for. One manager can be responsible for multiple products.

I have attached an example which shows what I have right now.
Small clarification:
- RawData contains the daily gathered info
- A list is created based on Product under the Master tab
- A link on the RawData is created to avoid the "You can only copy data to the Active Sheet" error.
- A Macro is created to filter the data, and assigned to the button on the Filter tab

Currently you can select per product and show that data.
The goal is to select a Manager and then show the data he's responsible for (Manager Mike will show all lines containing products "Prod X and Prod Y")

While we're on the filtering, what is needed in the Macro code to only display active fields (ie. not show Unused)?

Thanks in advance!

[daxy]

Anyone has any suggestions for this one?
I'm really stuck here

Thanks a million!

[KatDunlap]

I am sure others will come up with other better solutions but what I would probably do - is on another tab have list of managers with the products they look after. Then create a new column on the master sheet with a vlookup formula to pull through the correct manager to that product - then you can filter by manager.

I cant open your link so dont know whether this would work for you.

[daxy]

I figured it out!
See the attached updated sheet for the working example.

I have created a "Manager mapping" table on the sheet named Master
On the Filter sheet I've created a VBA script which populates fields C6-8 when C5 is modified
On the RawData field the Cells H2-4 are automatically linked and now the previous Macro works fine (after the selection was updated in the Macro).

I hope this helps you as well