Use a different worksheet in a different workbook drop down menu
 

i can not get it to work at all

Use a different worksheet in a different workbook drop down menu
 

Check out this page from Debra Dalgleish:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
uk"
wrote in message ...
i can not get it to work at all