Combining two spreadsheets into a third

AssociateRMG

New Member
Joined
Nov 8, 2010
Messages
1
Okay, I've been pounding my head against this one for eons, so I now come to you, masters of all things Excel, begging for assistance! I have two spreadsheets, one far larger and more complete than the other. There are multiple columns that overlap between the two.

What I need to do is generate a third spreadsheet that takes all the entries from the smaller spreadsheet, and fills in the blanks from the comparable column in the larger spreadsheet. That is to say, Columns A, B, C and D are in both spreadsheets. I need a new spreadsheet that takes all of the entries from spreadsheet 1 that have a Column A and B match in the far larger spreadsheet 2, and fills in the data in columns C and D that are missing in spreadsheet 1, but not in spreadsheet 2. There MUST be a way to do this with a macro. :confused: Does anyone have any ideas?
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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,167,645
Messages
5,854,913
Members
431,682
Latest member
kobenix

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