Hello!
I have columns A and B in sheet1,workbook1, and columns A and B in sheet2,workbook2. The code below checks for the duplicates between the two workbooks by comparing columns A and B in sheet1 and sheet2:
What I would like to do now is to achieve some sort of reverse engineering of that code above. I'd like to compare the values of column A and column B from sheet2,workbook2 into ALL the sheets in workbook1 and delete them from workbook 1 if it is found.
Any help would be greatly appreciated. Thank you.
Bookmarks