Statistic layout with Drop-Down list with multi selections

[petmak]

Good Day.
I need VBA expert help.
I have the attached file that comparing data between two tables ( New & Old )
so simply the code in B5 reading from these two tables and get the necessary information ( Total Count transactions ) and display them next to each other in Colum B5 and C5 new and historical for comparison.
as it is the codes look to the entire data and gets the total count which is ok
The challenge is to add Drop Down list in A3 and get from these two tables everything but with selected list.
for example if I want to see totals transaction in both tables but only for NewZeland, Australia, Russia. and for EUR and AUD
I can adjust the codes and add drop-down list but it will be single selection using ( data Validation the list )
is it possible to do something to keep the same list but giving me this option to choose all or more than one option and also should work with the code in B5, C5, D5 etc
Thank you for your help in advance

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...c-layout.htmle