I have 2 workbooks stored on networked Drives.
WorkBook A is the main file, WorkBook B is the reference file.
WorkBook A has a list of part numbers in column B (some of which are repeated, and they are not in certain order)
WorkBook B has a list of part numbers on constraint in column C (the number of rows will fluctuate)
I would like the user to be able to open both WorkBooks and have the Macro highlight the matches on WorkBook A.
Found this but it did not work:
Any help would be appreciated.Please Login or Register to view this content.
Bookmarks