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