Need help creating an Excel VBA script to search for matching stings on one workbook of strings from another workbook

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.

Please advise.



Read more here: https://stackoverflow.com/questions/64960712/need-help-creating-an-excel-vba-script-to-search-for-matching-stings-on-one-work

Content Attribution

This content was originally published by KidAce at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: