I have two work books. One called “Domains” and the other called “Master”.
The “Master” workbook contains one column, with 1346 rows of fully qualified email addresses, whereas the “Domains” workbook contains one column, with 941 rows of domain names only (starting with @ sign)
What I’m looking to do is have a VBA script that will take each string from each individual cell, within the single column in the “Domains” workbook, and search for a match within the “Master” workbook. When found, highlight the row containing the matching string.