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