Matching First/Last Name and Combining Info into New Sheet

faceplant247

New member
Joined
Feb 28, 2013
Messages
1
Reaction score
0
Points
0
I’m trying to combine information from two spreadsheets into one by matching the last name and first name from each.

So, for instance, in sheet 1, I have last name and first name in separate cells followed by info in cells after. In a separate sheet I have (in about half of the cases) the same Last Name and First Name followed by different info in cells after.

I want to combine the two sheets into one sheet by matching the Last Name and First Name followed by all of the pertinent info from both sheets.

If the Last and First Name is not present in both sheets I still want it to populate in the new sheet with Last and First name followed by the info from the 1 sheet.

Any help is appreciated.
 

Simi

New member
Joined
Feb 10, 2012
Messages
190
Reaction score
0
Points
0
Location
Utah, USA
Excel Version(s)
Version 2002 Build 12527.20194
You would be better using a macro for this instead of a formula, hows your VBA skills?
 
Top