Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy data from one workbook to another?
I have two excel workbooks that I need to update data from workbook 1 into workbook 2. The workbooks are both customer lists with customer assigned to each person. In one book I have a customer code (A,B, or C) assigned to each customer number. I need to copy that code for each customer and enter it in a new column in workbook 2. For example cust# 123 has code B assigned to them, I need to go into workbook 2 and assign B to cust# 123. I have about 11,000 entries to do this for. Any help? -- Lovelock, David ------------------------------------------------------------------------ Lovelock, David's Profile: http://www.excelforum.com/member.php...fo&userid=2826 View this thread: http://www.excelforum.com/showthread...hreadid=376403 |
#2
|
|||
|
|||
I'd probably use VLOOKUP to do this.
http://www.mvps.org/dmcritchie/excel/vlookup.htm "Lovelock" <Lovelock, "David" wrote: I have two excel workbooks that I need to update data from workbook 1 into workbook 2. The workbooks are both customer lists with customer assigned to each person. In one book I have a customer code (A,B, or C) assigned to each customer number. I need to copy that code for each customer and enter it in a new column in workbook 2. For example cust# 123 has code B assigned to them, I need to go into workbook 2 and assign B to cust# 123. I have about 11,000 entries to do this for. Any help? -- Lovelock, David ------------------------------------------------------------------------ Lovelock, David's Profile: http://www.excelforum.com/member.php...fo&userid=2826 View this thread: http://www.excelforum.com/showthread...hreadid=376403 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Copy data into a NEW worksheet | Excel Discussion (Misc queries) |