Hello everyone,
Need help on something.
I get two workbooks sent to me. One from my Home Office IT department
and one from our corporate Home Office. They basically contain the
same information, but one may have extra fields that the other doesn't.
For the fields that are similar in data, they may be in different
columns. For instance Name Of Client may be in Column A in
WBHomeOffice and in Column B in WBCorporateOffice.
So, how can I combine these workbooks to merge into a master sheet and
"map" the columns appropriately?
TIA
Brian
Bookmarks