exceledsoftware,

Your code is different form what I was trying to with no luck.
I was attempting to use a filter using an "Array". But, that proved to be a little difficult.
Hiding the rows as you did looks good. But, what does the user want to do with the data after the code runs?
Does the user want to do each country separately or as your code does at the same time.
Also the user did not provide data in sheet1 that was in sheet3.
Perhaps the user will give us more information as to how they want to handle this.