Merging Data from two Excel Workbooks using a Unique Identifier
Posted on 2013-11-02
I have two large workbooks. One of which contains names, a unique identifier, and certifications. The other one has the same unique identifier, names and address information. Since I am trying examine and sort the certifications by regions I need to have the certs and address info in the same sheet.
Is there a way to merge these two using say the unique identifier common to both so that I can work with the resultant file easier.
I have over 300,000 records in one of the files so they are pretty large.