Compare 2 lists and merge

[sanjay]

Hi,

Could someone help please, I have 2 worksheets 20 columns in each (both
sheets have identical row headers) and 30-40 rows, in column A of both
sheets is a field that may or may not appear in both sheets, what I
would like to do is merge the information from both sheets and create a
master list in sheet3 is this possible?

I have attached a sample workbook if this helps!

Regards,

Sanjay


+-------------------------------------------------------------------+
|Filename: merge list.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3684 |
+-------------------------------------------------------------------+

 

[Guest]

not enough information.
Why not simply move table2 and append it to table1

Are the items in column A supposed to be unique? If so, when the item is on
both tables, what data columns do you take - from table1 or table2? Or maybe
add them together?

 

[sanjay]

Sorry Patrick,

I hope this makes sense:

Sheet 1
ID B C D
A1 2 4
A2 3 5
A4 4 4
A5 5 5

Sheet 2
ID B C D
A1 3 4
A2 1 3 5
A3 5 6 7
A6 6 6 6


Sheet 3 (merged sheet)
ID B C D
A1 2 3 4
A2 1 3 5
A3 5 6 7
A4 4 4
A5 5 5
A6 6 6 6

Regards,

San

 

[Patrick Molloy]

what if

Sheet 1
ID B C D
A1 2 4
A2 3 5
Sheet 2
ID B C D
A1 3 4
A2 1 4 5

in A2 column C. would you take the 3 or the 4?