Hi
I have a table in a sheet.
I want to import data from the table to labels in a userform.
The table looks like this
Column A = Names
Column B = City
Column C = Country
NAMES | CITY | COUNTRY
Oskar | stockholm | sweden
Sven | london | england
Jenny | paris | france
Lucas | malmö | sweden
Olle | newcastle | england
I want some VBA code to import the names of those that live in Sweden for example.
So the label in this example should look like this "Oskar, Lucas"
In another label i want to import those that live in england for example.
Like this "Sven, Olle"
How would i do this?
I have a table in a sheet.
I want to import data from the table to labels in a userform.
The table looks like this
Column A = Names
Column B = City
Column C = Country
NAMES | CITY | COUNTRY
Oskar | stockholm | sweden
Sven | london | england
Jenny | paris | france
Lucas | malmö | sweden
Olle | newcastle | england
I want some VBA code to import the names of those that live in Sweden for example.
So the label in this example should look like this "Oskar, Lucas"
In another label i want to import those that live in england for example.
Like this "Sven, Olle"
How would i do this?