matching data on two separate worksheets

J

jodi

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.
 
J

Joel

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
How to have two tables on same line? 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Linked cells between worksheets and sorting 2
Splitting a cell into two... 3
Merging data from different worksheets 1
Index Match to add employee number 2
merging two large spreadsheets 2

Top