Debra Dalgleish has a short video he

http://www.contextures.com/xlVideos07.html#DataVal01

which shows how to set up Data Validation from a list in another
worksheet.

Hope this helps.

Pete

On Aug 22, 11:17*pm, Gerardo
wrote:
In the help file it says you can link a pop up menu (data/validation) *from a
list in another workbook if you create a name in your worksheet and you link
the reference to the list in the second workbook.

In real life that doesn't happen, you get an error saying you can't *feed
the pop up menus (data validation) from references in another workbook even
though you do it in an indirect way as suggested by the help file.

Any thoughts?

Regards