Hi Team,
Hello Team,
I need code on the below scenario:
I have data dump which contains 15 columns of data. I need code to perform the below steps:
Col A(Region), Col D(country), Col J(comments).
For eg: I filter the Col A (Region) by "ANZ". Then column D(country) contains like PAK, ENG, AU, NZ etc.,(In this PAK and ENG is not part of ANZ I need to replace this with one conditon i.e., based on comments in Col J) , I will see the column J(comments) based on the content if it contains AU/NZ i ll replace the column D contents with the same. OR if it contains other than AU and NZ anything(eg Ind, Pak, ENG ) I will replace by default as AU. , How do I do this by coding.
I need to do the same for different region based on different condition. I have made a list as well for all the region. How do I make this by VBA.
Regards,
Vin
Hello Team,
I need code on the below scenario:
I have data dump which contains 15 columns of data. I need code to perform the below steps:
Col A(Region), Col D(country), Col J(comments).
For eg: I filter the Col A (Region) by "ANZ". Then column D(country) contains like PAK, ENG, AU, NZ etc.,(In this PAK and ENG is not part of ANZ I need to replace this with one conditon i.e., based on comments in Col J) , I will see the column J(comments) based on the content if it contains AU/NZ i ll replace the column D contents with the same. OR if it contains other than AU and NZ anything(eg Ind, Pak, ENG ) I will replace by default as AU. , How do I do this by coding.
I need to do the same for different region based on different condition. I have made a list as well for all the region. How do I make this by VBA.
Regards,
Vin