i have all countries in column A in sheet 1 and some countries in column A in sheet 2. how can i highlight same countries between two sheets from column A to Z in sheet 1; with a macro
for example in sheet 1 column A is:
Albania
Algeria
Bangladesh
Belarus
Belgium
Belize
Benin
Bhutan
Bolivia
Botswana
Brazil
Bulgaria
Burundi
...
and in sheet 2 column A is
Algeria
Belarus
Belgium
Benin
Bhutan
Bolivia
...
please note that:
i got countries data from different sources that nominate countries with different roles.
for example Word Bank say "korea, dem. rep." and IMF say "korea, democratic people's republic of" and United Nations say "korea, dem. people's republic of (north korea)". this problem repeats for many other countries. can i have a macro that can find common countries in two sheets without considering they suffix or prefix
sincerely yours
i asked this question also here:
http://www.mrexcel.com/forum/showthread.php?t=390850
Bookmarks