under data validation choose list
a formula similar to this will work:
=INDIRECT("[Book3]Sheet1!$A$1:$A$19")
--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile:
http://www.excelforum.com/member.php...o&userid=36330
View this thread:
http://www.excelforum.com/showthread...hreadid=563757