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.
Does anyone have any ideas?
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.
Does anyone have any ideas?
