I have two excel worksheets that I need to merge and then would like to sort the information so that the names align.
One sheet has columns Last Name, First Name, Age and the other sheet has columns Last Name, First Name, Address. Since some names are missing on each sheet, I'd like to sort the list and match the last names.
Does anyone know the VBA code for this?
It would be easiest to use two vlookups: one to bring either the age or address from one sheet onto the other, and the other to identify any names missing on the "merged" sheet. If you post a sample worksheet with a portion of the two lists I can show you how, though please scrub the sheets of any personal info.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks