matching data on two separate worksheets

G

Guest

Can anyone give me a succinct way to match two sets of information relating
to names (as matching field(s)) and merging both sets of information on one
line to create a new full record for each name.

eg One worksheet contains Forename, Surname and various field containing
personal details ie e-mail, dob, gender, address etc.
The other worksheet contains Forename, Surname and various fields containing
information relating to business processes ie purchased items or similar.

Merging the two sets of data together either on one of the originals or to
another worksheet?

Would be grateful for any assistance.
 
G

Guest

The simpliest way if both sheet have the same number of row. Sort each
worksheet by Forename and Surname. Then copy Columns C to last column on one
worksheet, and paste data after last column on 2nd worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning matched employee number from a different sheet 2
Merging data from different worksheets 1
Matching data on two workbooks 3
Index Match to add employee number 2
merging two large spreadsheets 2
Matching names and combining worksheets 5
matching data on worksheet 1
Matching identical data using data only once in the matching proce 1

Top