This question already has an answer here:
I have two workbooks which I need to merge. On workbook_1 I have column A with 5 letter codes and in column B I have numbers for what is on hand. On workbook_2 I have column A with the 5 letter codes, but some are different and some are the same as in column A from workbook_1. On column B this time I have numbers for what is authorized.
I need to combine column A from both workbook_1 and workbook_2 and keep the numbers from column B from both workbooks.
Column A: Column B: CODE ON HAND ZWRAA 2 TRSAA 5 RSTAA 6 TRWA1 4 TRWA2 8 TRWA3 3
Column A: Column B: CODE AUTH ZWRAA 5 TRSA1 6 TRSA2 9 TRWAA 7 TRWA2 2 YTSAA 1
This is what I need to see after I combine both workbooks:
CODE ON HAND AUTH ZWRAA 2 5 TRSAA 5 0 TRSA1 0 6 TRSA2 0 9 RSTAA 6 0 TRWAA 7 0 TRWA1 4 0 TRWA2 8 2 TRWA3 3 0 YTSAA 0 1