Hey all,
I'm working on a project where I need to search the contents of a couple different columns of data (columns K & L in the "3D Printing Patents" tab of the attached workbook) for substrings contained on a separate worksheet (COL A of the "Replace List" worksheet). When a substring is found in a cell in columns K or L, I'd like to replace the entire contents of that cell with the string that correlates to the substring found (COL B in the "Replace List" worksheet.)
I need the operation to NOT be case sensitive. I have a macro in the attached worksheet that works to replace with a particular string that is listed there in the macro, but I'm admittedly pretty inexperienced with VBA and don't know how to modify it to do what I need it to do. Can you guys/gals help?
Thanks,
Rob
Bookmarks