Macro to populate the tables from Pivots, when values are selected from drop downs.

Hi,

need a Macro to populate the tables from Pivots, when corresponding Region and Country are Selected.

Country drop down is dependent on the region.

When nothing is selected it should be the total of all regions.

I have attached the data and corresponding Pivots are also created.

Any help on this is appreciated.

Thanks,

Pavan.