Justinbodden
09-17-2015, 07:10 AM
Hi All-
I am a novice VBA user so please bear with me.
I have a very simple IF statement that I want to execute in VBA. I have over 100 countries and I want a code that inserts in the empty column to the right of countries the corresponding region.
I.E- IF K10 = France Then L10 = Europe.
I.E. IF K11 = United States Then L11 = North America.
I need to do this for 138 countries.
How can I do this in VBA?
Any suggestions or faster alternatives?
I need to automate this task because we do have to do it for a monthly report and it takes to long to do a standard If statement.
Thanks in advance for all of your help. I am really excited to be apart of this community.
Regards,
Justin Bodden
I am a novice VBA user so please bear with me.
I have a very simple IF statement that I want to execute in VBA. I have over 100 countries and I want a code that inserts in the empty column to the right of countries the corresponding region.
I.E- IF K10 = France Then L10 = Europe.
I.E. IF K11 = United States Then L11 = North America.
I need to do this for 138 countries.
How can I do this in VBA?
Any suggestions or faster alternatives?
I need to automate this task because we do have to do it for a monthly report and it takes to long to do a standard If statement.
Thanks in advance for all of your help. I am really excited to be apart of this community.
Regards,
Justin Bodden