matching data on two separate worksheets
 

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.

matching data on two separate worksheets
 

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.

"jodi" wrote:

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.