Hi everyone,
I need a VBA code that can compare a master list to lists in other sheets (could be an unlimited amount of sheets), and highlight the locations of the the non-matches and take the users to those locations. For example, if on the master list it says apple, and on sheet 2 column a it says lemon, the program should take the user to where it says lemon so, they can change the list entry to apple. Thanks.
I need a VBA code that can compare a master list to lists in other sheets (could be an unlimited amount of sheets), and highlight the locations of the the non-matches and take the users to those locations. For example, if on the master list it says apple, and on sheet 2 column a it says lemon, the program should take the user to where it says lemon so, they can change the list entry to apple. Thanks.