Book1 and Book2 are just examples. R15 is not on the list because I jus
wrote an example, (To be honest I'am suprised R15 is the only one not o
the list.) I can't give exact data as all the information I have i
"confidental". I was hoping to just give an idea of what it was
needed.
I tried the Vlookup and it did not work properly. sometimes th
Reference Designator in column A of Book1 is not always not in Book2 s
I need the cell in column B in Book1 to remain empy. My goal is to b
able to run a macro and have as little employee interaction with th
data as possilbe.

Thank you for all of your help so far,
Dre

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