Define a name (Menu:InsertNameDefine...)
Name: list
Refers to: =DataValWb.xls!CustName
Then use Validationtab Settings, Allow:List, Source: =list

Ola

Source: http://www.contextures.com/xlDataVal05.html


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378975