Hi, I can't find a tutorial on what I need to do and thought maybe I'm searching online with the wrong keywords. I hope to get some advice and/or pointed in the right direction.
I have two excel sheets. I want to merge the two sheets but only have the duplicates rows kept and anything that is not a duplicate to not be merged into the sheet.
On my sample sheets column B the Job Numbers is what is being compared to find duplicates. Anything without a duplicate in column B should not be merged.
Main Sheet Inspection is the main spreadsheet.
Thank you for any input
Kimberly
Bookmarks