Compare and Remove Duplicates between Two Excel Sheets
Posted on 2014-03-10
I know how to create a macro to delete dups on the same sheet, but I need one to remove from different sheets.
I have two identical sheets, but I need them to stay seperate. I would like to to compare Sheet One to Sheet Two using columns B, C, D K. If there are duplicates, I would like them removed from Sheet One Only.
I would like this done using VBA.