Finding A Desciption In Another Book
 

I have been trying to figure out a way to speed up the way I progam
project.
Every day I have to program a circuit borad to run on a machine.
The set up is
EXAMPLE:
BOOK1
COLUMN A COLUMN B COLUMN C
COLUMN D

C1 DESCRIPTION X-DATA
Y-DATA
C2 DESCRIPTION X-DATA
Y-DATA
C3 DESCRIPTION X-DATA
Y-DATA
C4 DESCRIPTION X-DATA
Y-DATA
R3 DESCRIPTION X-DATA
Y-DATA
R45 DESCRIPTION X-DATA
Y-DATA
R56 DESCRIPTION X-DATA
Y-DATA
ect,ect,ect DESCRIPTION X-DATA
Y-DATA

in a seperate book I have a description list that looks something lik
this
Example:
BOOK2
COLUMN A COLUMN B
C1,C2,C4,C10 0.1UF_10V_0805
R45,R49,R16,R1 10K_1%_0805
ECT,ECT,ECT ECT,ECT,ECT

I need a macro that can look on the two open workbooks and find th
referance data in column a in book1 and then find it in book2 and the
enter the correct description in column b in book1. Keeping in min
that I do up to 10000 programs a week and all are different. They al
have the same setup.

Thank you in advance.
Dre

--
drew
-----------------------------------------------------------------------
drewd's Profile: http://www.excelforum.com/member.php...fo&userid=1474
View this thread: http://www.excelforum.com/showthread.php?threadid=26567

Finding A Desciption In Another Book
 

Not quite sure of your data but something like

=VLOOKUP(A2,[Book1.xls]Sheet1!$A$2:$D$100,2,FALSE)

If you want some flexibility in workbooks, you could store the wrokbook name
in a calle and use say

=VLOOKUP(A2,INDIRECT("'["&H1&"]Sheet2'!$A$2:$D$100"),2,FALSE)
with the workbook name in H1

--

HTH

RP

"drewd" wrote in message
...

I have been trying to figure out a way to speed up the way I progam a
project.
Every day I have to program a circuit borad to run on a machine.
The set up is
EXAMPLE:
BOOK1
COLUMN A COLUMN B COLUMN C
COLUMN D

C1 DESCRIPTION X-DATA
Y-DATA
C2 DESCRIPTION X-DATA
Y-DATA
C3 DESCRIPTION X-DATA
Y-DATA
C4 DESCRIPTION X-DATA
Y-DATA
R3 DESCRIPTION X-DATA
Y-DATA
R45 DESCRIPTION X-DATA
Y-DATA
R56 DESCRIPTION X-DATA
Y-DATA
ect,ect,ect DESCRIPTION X-DATA
Y-DATA

in a seperate book I have a description list that looks something like
this
Example:
BOOK2
COLUMN A COLUMN B
C1,C2,C4,C10 0.1UF_10V_0805
R45,R49,R16,R1 10K_1%_0805
ECT,ECT,ECT ECT,ECT,ECT

I need a macro that can look on the two open workbooks and find the
referance data in column a in book1 and then find it in book2 and then
enter the correct description in column b in book1. Keeping in mind
that I do up to 10000 programs a week and all are different. They all
have the same setup.

Thank you in advance.
Drew


--
drewd
------------------------------------------------------------------------
drewd's Profile:
http://www.excelforum.com/member.php...o&userid=14749
View this thread: http://www.excelforum.com/showthread...hreadid=265679