Here's an example

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


Regards,


Peo Sjoblom


"Mike" wrote:

Thanks for the reply.... I have done both steps but
I still get the error message "You may not use references to other
worksheets or workbooks for data validation criteria".
What have I missed?
Thanks again, Mike.

"Peo Sjoblom" wrote:

1. If you mean datavalidation you need to name the list in the other workbook.
2. The other workbook needs to be open, you cannot use a list from a closed
workbook


Regards,

Peo Sjoblom



"Mike" wrote:

How do I link to (and be able to choose data from) a drop list in another
workbook?
Every time I try to type in the path, an error message says its not allowed.
Is there
a way around this problem?
Thanks for any help....