Combining Sheets

[berg891832]

Okay, here is my Situation. I have two sheets: Sheet1 and Sheet2. Both sheets have essentially identical information - SSN, Name, Address for the same 200 people but sheet1 has some different people. However, Sheet1 has some different column headings than Sheet2. I am trying to combine both sheets together. Is there a way to do this easily? Thanks in advance.

 

[BigC]

If you just want to combine the data from both sheets into one without repitition (i.e a single database) identify the sheet that you think is more complete (i.e has more names in it) - say Sheet 1.
In Sheet 2 use vlookup formulae
=vlookup(sht2namecell,sht1namesrange,1,false)
to identify which names are not in sheet 1 (will return a "N/A" error.=>> copy those names into Sheet 1
In Sheet 1 use a vlookup formulae to return the required values from the Sheet 2 for each person - firstly for the data in sheet 2 for those people where there was a match in the first instance, and then for the additional data for those where there was no match.

HTH
Colin

 

[yosi]

in sheet 2 enter formula and copy it all the way down in coloumn D
=COUNTIF(Sheet1!A:A,A1)
( assuming that column A contain the names )
then use Filter to find all the 0 results in column D
copy the lines to sheet1
This message was edited by yosi on 2002-09-18 23:56