I have 2 workbooks, WBOOK1 and WBOOK2. Both have column A formatted exactly
the same. WBOOK2.A is a subset of WBOOK1.A. WBOOK2 also has 2 additional
columns not in WBOOK1. I would like to bring WBOOK2.B and WBOOK2.C into
WBOOK1, leaving them blank for rows that are in WBOOK1 but not WBOOK2 and
populating them in WBOOK1 as they are in WBOOK2 for rows that exist in both
WBOOK1 and WBOOK2.

I do not have tracking turned on, so I cant use the Microsoft merge tool (I
guess I could turn it on at the start). Currently what I am doing is
downloading WBOOK1 and WBOOK2 to our mainframe, do a left outer SQL join and
upload the result back to Excel. I essentially want to emulate this process
only doing it all manually in Excel.