HI,
I am looking to create VBA/Macro function to find concatenated values in cell from List of values was in other worksheet
In Excell :
in WorkSheet 1 "MainData" in Column B there are the following values :
A B C
1 FRA,USA,CANADA False
2 UK,FRA,GERMANY True
in WorkSheet 2 "Countries List" there is a list like the following
A
FRA
GERMANY
CANADA
USA
I am looking the statements to find FRA from WorkSheet 2 , USA from Worksheet 2 and so on ....
so when call the VBA function C1 will be False as B1 has UK which is not in the country list
can you help tell me the Statement !
Regards
Nahed
I am looking to create VBA/Macro function to find concatenated values in cell from List of values was in other worksheet
In Excell :
in WorkSheet 1 "MainData" in Column B there are the following values :
A B C
1 FRA,USA,CANADA False
2 UK,FRA,GERMANY True
in WorkSheet 2 "Countries List" there is a list like the following
A
FRA
GERMANY
CANADA
USA
I am looking the statements to find FRA from WorkSheet 2 , USA from Worksheet 2 and so on ....
so when call the VBA function C1 will be False as B1 has UK which is not in the country list
can you help tell me the Statement !
Regards
Nahed