List Validation

R

Renee

I was wondering if there was anyway you can have a drop down list in one
workbook that comes from a different workbook. Example: I have a workbook
saved with a list of names and I want to have that list of names come up in a
form that I have saved in another workbook.
 
R

Renee

I went to the site you have below and followed the instructions but when I
click OK in the data validation window I get a message that reads: The Source
currently evaluates to an error. Do you wish to continue?
What does this message mean? If I click 'yes' then my dop down list doesn't
work.

Renee
 
Top