I have two workbooks. The first workbook, is a download of products I have on our website. There are several columns, but I wish to only compare Column E which is the manufacturing ID to the second workbook Column A which is also the Manufacturing ID. I need to know which products in Workbook 1, column E do not match with Workbook 2, Column A and send this data to a third workbook for review. That way I can delete these products from our website.
I've attach a sample of Workbook 1 (Column E) and Workbook 2 (Column A)
Bookmarks