AutoMerge (Remove duplicate Data) outside of Excel?

Currently I have an exported list which has some columns of data, for reference let's just say there are 2 columns for "name", "phone number".
I add a third column for "notes"

Later, I export an updated list which will have all the same "name" and "phone number" but doesn't have the "notes" that were added obviously.

What we do now is manually copy the columns from the new sheet and paste it into the old sheet, then do a Remove Duplicates so it removes all the dupe names, keeping the original ones with their notes.

Wondering if there is some way to automate this by just selecting the two files rather than having to copy, paste, etc. It's easy for me but some of my co-workers it is confusing. Not sure if this is even possible without some coding or outside app.

(Maybe a VB button in the main file that pops up asking you which fie to merge in?)

Thanks in advance as always. This may need to be moved out of general?

I found a VB script that does exactly what I want, but it always removes the extra column (when it removes dupes it removes the Original item which has the extra info unfortunately.

Please Login or Register  to view this content.

I will attach a sample document with 2 tabs of data as an example. Just keep in mind my users have 2 files, not info in two tabs..just did it this way so I didn't have to attach two files.

I basically just want to merge them without losing the notes for customers.

Originally Posted by dflak

In the attached file, the control panel is used to set the path and file name to the source data.

The general logic is that it opens the source file and appends it onto the end of the existing data. So new customers get added. The RemoveDuplicates function assumes that the second, third, etc. item found are the duplicates and removes them. So existing customers without notes get removed, but new customers stay appended.

That works and it's really fast. A little less user friendly but I can work with it and make it work, thanks!