I have a list of full address in sheet 1 and list of all the province in sheet 2.
What I want is to loop through the entire row of address then checks if the address contains a specific province from my list then write that province besides the address.
First I read the range of the address and province and store in data table
Then I loop through province row using for each row data table and assign it to “sample” variable
After that I loop through the address row and checks if my address contains a province in my list