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
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

al_b_cnu

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

Watch MrExcel Video

Forum statistics

Threads
1,122,705
Messages
5,597,666
Members
414,162
Latest member
jborjal1967

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