Data Validation

S

Sean

That is correct. I have run into that before.
I have, in the past, created a user list somewhere else
in the sheet and then selected those cells and hid the
cell data. That was the only way that I have been able
to do that.

Sean
-----Original Message-----
I am trying to do a drop down menu in one workbook and
getting the list of data from another workbook. I did
define name on both workbooks and try to do Data
Validation, I am gettinf this message "You may not use
references to other worksheets or workbooks for Data
Validation criteria". Can someone help me on this.
 
Top