I'm extremely new to Excel and Macros and struggling here with this requirement.
I have a column having country names. The names in this column could be a single country or a list of countries separated by a semicolon. I want to write a macro which will look at the value in this first column, and populate the geographical region of that country into another column. However, in case this column has multiple countries separated by semicolon, the second column should also have multiple geographical regions separated by semicolon.
See example below:
How do I go about writing this macro?
Many thanks for helping me out!
I have a column having country names. The names in this column could be a single country or a list of countries separated by a semicolon. I want to write a macro which will look at the value in this first column, and populate the geographical region of that country into another column. However, in case this column has multiple countries separated by semicolon, the second column should also have multiple geographical regions separated by semicolon.
See example below:
How do I go about writing this macro?
Many thanks for helping me out!
