I have 2 separate workbooks. I want to carry/copy one column in workbook A to workbook B, but only carry/copy over that one column, the values in the "status" column. Since some employees are removed and some are added, I can't simply copy and paste the entire "status" column from workbook A to B. I want to use column A as the unique identifier, then copy the values in the status column from workbook A to B, but to copy only for the employees that still exist in workbook 2. From workbook 1 to 2, employee number 13 is not longer present, so that entire row for employee 13 shouldn't carry over into workbook 2. I've highlighted in red what needs to be carried/copied over from workbook 1 to 2.
For example, here is the sample dataset from the 2 workbooks:
<colgroup><col style="mso-width-source:userset;mso-width-alt:3185;width:67pt" width="90"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3384;width:71pt" width="95"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
For example, here is the sample dataset from the 2 workbooks:
workbook 1 | ||||
employee | CITY | State | SALES | status |
8 | DALLAS | TX | $30,835 | 1 |
12 | SHREVEPORT | LA | $71,638 | |
13 | METAIRIE | LA | $245,013 | 3 |
19 | HARTFORD | CT | $181,049 | |
20 | BATON ROUGE | LA | $2,166,385 | 1 |
23 | OMAHA | NE | $24,132 | m |
29 | WATERBURY | CT | $937,589 | |
33 | JACKSONVILLE | FL | $21,980 | 1 |
35 | OMAHA | NE | $3,066,541 | |
49 | WATERBURY | CT | $240,774 | m |
workbook 2 | ||||
employee | CITY | State | SALES | status |
8 | DALLAS | TX | $42,184 | |
12 | SHREVEPORT | LA | $47,845 | |
19 | Hartford | CT | $252,426 | |
20 | BATON ROUGE | LA | $3,332,213 | |
23 | OMAHA | NE | $34,241 | |
29 | WATERBURY | CT | $1,402,102 | |
33 | JACKSONVILLE | FL | $28,294 | |
35 | OMAHA | NE | $4,839,064 | |
49 | WATERBURY | CT | $487,642 | |
55 | New Haven | CT | $33,670 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3185;width:67pt" width="90"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3384;width:71pt" width="95"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>