I need some help with the attached Excel file. You can see the code I have for FindNames. This should look at each name in Column G in "Macro Completed" sheet, and if that name is listed in "Names" sheet, it should replace value in Column E of "Macro Completed" with value next to name on Names Sheet (ST Name) as well as perform some formatting, etc. Right now it only does it for the first instance of each name found. I need it to work for entire sheet.