Mike,
I will probably be corrected but I don't think you can validate a list
from another workbook.

You could paste a link of your list from book 2 to book 1 and use the
list in book1 as your validation list.

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=379001