# Moving data from one workbook to another.

#### BlueJayGene

##### New Member
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 SN Sort P/N Removal Customer 1 Customer 2 Program Rec Month ABCD1234 D1234 1234567899 Scheduled Customer A Customer B Block 10 Nov-13 ABCC5432 C5432 1234569765 Unscheduled Customer C Customer J Block 8 Nov-13 ABCD1234 D1234 1234567899 Scheduled Customer A Customer C Block 10 Dec-13 ABCC5432 C5432 1234569765 Unscheduled Customer C Customer K Block 8 Dec-13

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

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

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### BlueJayGene

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

Replies
0
Views
581
Replies
0
Views
192
Replies
6
Views
929
Replies
4
Views
2K
Replies
4
Views
191

1,195,582
Messages
6,010,581
Members
441,557
Latest member
Jbest23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back