Copy data from one workbook to another?

[Lovelock, David]

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?

[Barb R.]

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