Adding 2 columns of data with if condition

Hi all,

I have been facing some problem. The sample data is attached with this post. I did the codes for adding of column B & E with the header of "FSI/Non-FSI" and "Branch" respectively, under the macro name "sbInsertingColumns".

After running the macro to add the two columns, i want the data to be filled in with the conditions of:
FSI/Non-FSI (column B):

if "Country" = "Singapore" then under the FSI/Non-FSI column B, it will display "Non-FSI", else if country is not "Singapore", it will display "FSI".

Branch (column E):

if "Country" = "Singapore" then under the Branch column E, it will display "Local", else if country is not "Singapore", it will display "Oversea".

I hope to hear from you guys and I appreciate any help from anyone out there. Thank you

try add 2 lines

Please Login or Register  to view this content.

Hi Jindon,

Thank you so much for your help. And yes, is working fine now.

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Originally Posted by jindon

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Hi Jindon, I try it out on my another excel data and change the code abit and only managed to run the marco so that it can show the branch. Can you help me with the FSI/NonFSI code.

Change "e" to "j"
to

Please Login or Register  to view this content.

Thank you so much!