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(states) 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) , 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. I have made a list as well, How do I do this by coding. Thanks, Vin -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
