I am looking for a macro to work on the selected worksheet. Compare all cells that have data in them to a list in another work book. If any cells contain a match with the workbook i wanted to highlight them yellow.
Typical work sheet has Part number, Description, Quantity as the different columns. The Workbook master list (saved in local directory) has a list of part number and description. The list contains key items for review so they need to be highlighted.
In the end i am going to attach the macro to the ribbon so it will be easy to use regardless of the workbook i am in. Any help would be greatly appreciated and thank you in advance!
Typical work sheet has Part number, Description, Quantity as the different columns. The Workbook master list (saved in local directory) has a list of part number and description. The list contains key items for review so they need to be highlighted.
In the end i am going to attach the macro to the ribbon so it will be easy to use regardless of the workbook i am in. Any help would be greatly appreciated and thank you in advance!