Hello guys! Thanks that you have devoted time to read my question. I will be very glad to get any help. 
So basically I have two sheets: with the world map and database. When you click on the county on the first sheet you transfer to database sheet, so there is a separate macro for each country looking like this:
Sub S_SWE()
Sheets("List of companies").Select
ActiveSheet.Range("$D$2:$D$9999").AutoFilter Field:=1, Criteria1:="=*SWE*", _
Operator:=xlAnd
End Sub
It simply indicates companies located in the chosen country.
Here is the question: How can I manage to make the same thing for two countries simultaneously? For example, so that people could choose Sweden alone or Sweden + Norway and get suitable results for companies working just in one country or in two of them.
Thanks in advance.
Bookmarks