Updating Old Data and Adding New Data to a Sheet

Hi all,

I'm having a tough time coming up with the question, but here goes.

I have a spreadsheet named "Master" that needs to be updated with certain data from another sheet named "UpdateData". They are both attached and I've shown the cell data here for ease of explanation.

Here is the "Master" sheet:
Key Column 1 Column 2 Column 3 Column 4 Column 5 Column 6
CY-001 $100 $200 $0 AAA BBB CCC
CY-002 $0 $0 400 DDD EEE FFF
CY-003 $1 $5 $7 GGG HHH III

Here is the "UpdateData" sheet
Key Column 1 Column 2 Column 3
CY-001 $100 $200 $300
CY-002 $1,000 $2,000 $3,000
CY-003 $1 $5 $7
CY-004 $5 $10 $15
CY-005 $25 $35 $50

I need to update the "Master" with data from "UpdateData". Here's what the result should look like:

Key Column 1 Column 2 Column 3 Column 4 Column 5 Column 6
CY-001 $100 $200 $300 AAA BBB CCC
CY-002 $1,000 $2,000 $3,000 DDD EEE FFF
CY-003 $1 $5 $7 GGG HHH III
CY-004 $5 $10 $15
CY-005 $25 $35 $50

You'll see that in the result, we've updated the data in Columns 1, 2 and 3 for CY-001, CY-002, and CY-003, and we've added the new rows for CY-004 and CY-005.

Short of working with VBA, does anyone have a suggestion on how to do this merger using a macro?

Thanks much in advance.

Hi,

You can use vlookup formula.

Please check the attached file..hope this should be help you.

Rahul

Thanks for the reply Rahul....I just wasn't clear enough on my post. The data I provided is just an example, and is actually dynamic relative to the values in columns 4, 5, and 6. Basically, once I've got the data from columns the "key" column and columns 1, 2, and 3, I need to make MANUAL entries into columns 4, 5, and 6. This is just the way it has to be....there's no way that this can be set automatically because in my actual situation, I need to consider each entry case by case...it would be absolutely impossible to do this with code.

The idea is for me to only conduct the analysis once on the record, make my manual entries as needed, and then have those manual entries held when other updates are made to the other fields within the record.

I hope this makes some sense...

Thanks