Compare and Merge non-shared large excel documents

[Paula Courtemanche]

Good Morning;

I have 2 large excel documents; approximately 3,000 rows each; they are similar, but not exact duplicates. (1 is from corporate; 1 is from a branch); I need to create 1 file with both sets of data in it; and there are multiple duplicates. Compare and Merge can't do this because they are not shared workbooks. When I share them I get an error message stating that there hasn't been enough history to compare and merge. Import is messy; and I like the idea of creating an Access database, however this is something that needs to be merged and updated monthly; and personnel will not know how to pull this information from Access.

Any suggestions?

P.S. I know basic Visual Basic;

Thank you.

Paula

 

[al_b_cnu]

Hi Paula,

Can you append the two sheets, sort them and then delete the duplicates?

[edit] Delete using Advanced Filter with Unique records only)

 

[paulac]

Thank you for your response;

However, when I tried this, there were too many duplicates' and the program doesn't know which ones I wanted to keep... All I need to do is import the different rows into the original spreadsheet; keeping the original spreadsheet information that is already there alone. Is there a way to bring both down to CSV to compare and merge, and then bring back into excel?