Hide Rows except for items selected in Drop-Down Menus.

[PatOwen]

I have a list of 246 countries. I have 10 drop-down lists, allowing the user to select 10 different countries. I have assigned each country with the corresponding number they have in the drop-down list for ease of programming. After the selection has been made, the user will click on a "Generate" button that will produce on a separate sheet the list of countries they selected. Or rather hide the countries they did not select, for the 'output' sheet has a row for each country in the list. I am wondering if there is a different approach in VBA to hide all rows except the selected countries or what the code would be in VBA to lookup the value selected from the drop-down and hide all countries except for the selected countries.

Thanks,
Pat