Compare and Merge non-shared large excel documents

Paula Courtemanche

New Member
Joined
Feb 23, 2007
Messages
2
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
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

al_b_cnu

Well-known Member
Joined
Jul 18, 2003
Messages
4,526
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

New Member
Joined
Aug 27, 2007
Messages
1
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?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,871
Messages
5,834,145
Members
430,261
Latest member
quangtinator

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top