Can you send a sample file? On Feb 22, 9:00 am, vinu <vinu1sm...@gmail.com> wrote: > 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
