Moving data from one workbook to another.

[BlueJayGene]

I have two workbooks – and wish to extract data from the first workbook (second tab), and insert certain cell data into a specific cell in the second workbook (first tab).</SPAN>
The first workbook has this info: </SPAN>

SN</SPAN></SPAN>	SN Sort</SPAN></SPAN>	P/N</SPAN></SPAN>	Removal</SPAN></SPAN>	Customer 1</SPAN></SPAN>	Customer 2</SPAN></SPAN>	Program</SPAN></SPAN>	Rec Month</SPAN></SPAN>
ABCD1234</SPAN></SPAN>	D1234</SPAN></SPAN>	1234567899</SPAN></SPAN>	Scheduled</SPAN></SPAN>	Customer A</SPAN></SPAN>	Customer B</SPAN></SPAN>	Block 10</SPAN></SPAN>	Nov-13</SPAN></SPAN>
ABCC5432</SPAN></SPAN>	C5432</SPAN></SPAN>	1234569765</SPAN></SPAN>	Unscheduled</SPAN></SPAN>	Customer C</SPAN></SPAN>	Customer J</SPAN></SPAN>	Block 8</SPAN></SPAN>	Nov-13</SPAN></SPAN>
ABCD1234</SPAN></SPAN>	D1234</SPAN></SPAN>	1234567899</SPAN></SPAN>	Scheduled</SPAN></SPAN>	Customer A</SPAN></SPAN>	Customer C</SPAN></SPAN>	Block 10</SPAN></SPAN>	Dec-13</SPAN></SPAN>
ABCC5432</SPAN></SPAN>	C5432</SPAN></SPAN>	1234569765</SPAN></SPAN>	Unscheduled</SPAN></SPAN>	Customer C</SPAN></SPAN>	Customer K</SPAN></SPAN>	Block 8</SPAN></SPAN>	Dec-13</SPAN></SPAN>

<TBODY>
</TBODY>

This is a very large data set. The S/N will appear multiple times. The rest of the data will change with each entry, but there are some exceptions where it may be the same.</SPAN>
The second workbook has this data:</SPAN>

ID</SPAN></SPAN>	S/N</SPAN></SPAN>	A</SPAN></SPAN>	B</SPAN></SPAN>	P/N</SPAN></SPAN>	Born-on-Date</SPAN></SPAN>	Date Rec</SPAN></SPAN>	Ship Date</SPAN></SPAN>	Customer 1</SPAN></SPAN>
123456</SPAN></SPAN>	ABCD1234</SPAN></SPAN>	1 thru 14</SPAN></SPAN>	Yes or No</SPAN></SPAN>	1234567899</SPAN></SPAN>	03/10/2007</SPAN></SPAN>	11/07/2013</SPAN></SPAN>	11/22/2013</SPAN></SPAN>	Customer A</SPAN></SPAN>
123457</SPAN></SPAN>	ABCC5432</SPAN></SPAN>	1 thru 14</SPAN></SPAN>	Yes or No</SPAN></SPAN>	1234569765</SPAN></SPAN>	04/25/2011</SPAN></SPAN>	11/14/2013</SPAN></SPAN>	11/26/2013</SPAN></SPAN>	Customer C</SPAN></SPAN>
123458</SPAN></SPAN>	ABCD1234</SPAN></SPAN>	1 thru 14</SPAN></SPAN>	Yes or No</SPAN></SPAN>	1234567899</SPAN></SPAN>	09/23/2012</SPAN></SPAN>	12/06/2013</SPAN></SPAN>	12/14/2013</SPAN></SPAN>	Customer A</SPAN></SPAN>
123459</SPAN></SPAN>	ABCC5432</SPAN></SPAN>	1 thru 14</SPAN></SPAN>	Yes or No</SPAN></SPAN>	1234569765</SPAN></SPAN>	01/07/2005</SPAN></SPAN>	12/12/2013</SPAN></SPAN>	12/31/2013</SPAN></SPAN>	Customer C</SPAN></SPAN>

<TBODY>
</TBODY>

This too is a very large data set. What I need to do is to find the S/N in the first table – based on the month – and replace the entry under Customer 1 with the associated Customer 2 data entry.</SPAN>
The VLOOKUP function can’t seem to handle the multiple S/N entries.</SPAN>
Any suggestions?</SPAN>

 

[BlueJayGene]

Sorry for this double posting of my question. I could not find my original till just now.