VBA for Lookup, Search etc
Posted on 2014-11-12
I have sheet 1 column A with names, sheet 1 column B with name, title. On sheet 2, column 1 contains an email header such as name <email address>; another name <email address>. I have been searching a combination of code for hours and possibly not looking up using the correct search terms. Can anyone guide me to some vba script for excel that will take the list of names in sheet 1, when they appear in sheet 2 (name <email address>), replace that name <email address> with the name, title from sheet 1?