Compare 2 lists and merge
 

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 |
+-------------------------------------------------------------------+

--
sanjay
------------------------------------------------------------------------
sanjay's Profile: http://www.excelforum.com/member.php...fo&userid=5915
View this thread: http://www.excelforum.com/showthread...hreadid=394780

Compare 2 lists and merge
 

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" wrote:


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 |
+-------------------------------------------------------------------+

--
sanjay
------------------------------------------------------------------------
sanjay's Profile: http://www.excelforum.com/member.php...fo&userid=5915
View this thread: http://www.excelforum.com/showthread...hreadid=394780

Compare 2 lists and merge
 

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

--
sanja
-----------------------------------------------------------------------
sanjay's Profile: http://www.excelforum.com/member.php...nfo&userid=591
View this thread: http://www.excelforum.com/showthread.php?threadid=39478

Compare 2 lists and merge
 

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?

"sanjay" wrote in
message ...

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,

Sanj


--
sanjay
------------------------------------------------------------------------
sanjay's Profile:
http://www.excelforum.com/member.php...fo&userid=5915
View this thread: http://www.excelforum.com/showthread...hreadid=394780