• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Remove Values in One List from Another List

Karthik

New Member
Hi,


I've a list of words in Col A of Sheet2 which I need to compare with list of sentences in Col A of Sheet1. If they match, that particular 'word' from the sentence should be removed.


I've posted a sample here: https://docs.google.com/spreadsheet/ccc?key=0Ao7RzFobcTErdElZQUpYODJUdkFNUXM3cGRWQ2V5T1E#gid=0


Any help here will be greatly appreciated!


Thanks!
 
Hi Karthik,


Can you please check the below post..


http://www.get-digital-help.com/2013/02/27/substitute-multiple-text-strings-vba/


You can manage to adapt the same by little bit trick..


https://dl.dropboxusercontent.com/u/78831150/Excel/Remove%20Values%20from%20Sheet%202%20in%20Sheet%201%20%28Karthik%29.xlsm


Regards,

Deb
 
Back
Top