Hello,
I have a workbook with sheet1 where you can see 3 columns, I need these columns to be compare against Workbook2 sheet 2 which also have the same 3 columns that way I will only have the information I really need in sheet2 from sheet 1. For example:
Sheet 1
Group LZ has position 3 and 6 and order # between 001 to 014
1.JPG
Sheet 2
Group LZ as you can see in the highlight have position 1 and 2 (which are not in sheet 1) and the order # of course are also not in sheet 1
2.JPG
I will like a way for those results that are not in sheet 1 to be highlight in sheet 2 so that way I can deleted them.
I have 10,000 records for different group position and order that needs to be compare against sheet 1.
Thank you.
Bookmarks