Forum Discussion
Excel Code trying to copy cell data from one sheet to another based on 2 criteria
Sheet "My Plan" Sheet "Tracker" I have several plans in external files that I have code for to select and import 1 to sheet "My Plan". I am using cell E6 as a named cell called PlanName and I sele...
You may try free CompareSheets (without space) add-in from Microsoft Store, it has also a built in algorithm that identifies the unique identifiers, as well has an option you can exclude from comparison (but not from output) columns that you do not want to track, will show what was changed in the rows and columns and therefore are merged in one output. I think that is what you are looking for.