Dear all,
I am tremendously thankful for your help in advance. Please do not kill me if it was already discussed before but I did not find it.
I thought I am good at Excel but I see I cannot solve the basic thing. And it would make my life so much easier.
I work for a big international company and we are managing rather extensive product portfolio. Therefore sometimes we need to quickly extract the portfolio of a particular country and sometimes to see the entire portfolio overview.
Therefore I am attaching the super-simplified version of some "made-up" small portfolio to express my issue. What I would like to be able to have an extra sheet where I can see the portfolio based on the country. Example: If I in the new "country selector" sheet choose France, I will not see all 5 products but only 222/11, 123/1, 122/1, since in the overview sheet you can see only these three products ticked for country.
So guys, is that doable? Can I make this selector? Is it too complicated?
Thank you guys for your help
Attached Images
CountryOverview.JPG
(97.7 KB)
Download
Attached Files
ExcelForumHelp.xlsx
(63.5 KB)
Download