Hi,

I noticed that in columns "C" and "D" starting at row 14 have duplicate values.
That is the "UK" has "UK:06: UK:07" 2 times. This I believe is predicated on the nr. of times a country is listed. If this is always the case the you would need to set the filter in sheet1 <> "UK:06: UK:07".
My question to you is will the data starting in row 14 column "C", "D" use the same pattern?
That is if row 14 has "UK:06: UK:07". Will row 15 be the same?
Also in sheet3 you have 2 different codes that = "Yes" but no correlation to this is in sheet1.
So I would assume that for sheet1 you would only need the filter only 1 time for the the data that <> "UK:06: UK:07".

Now once you set the filter for sheet1 what do you do with the filtered data.