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
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.
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
getting the list of data from another workbook. I did-----Original Message-----
I am trying to do a drop down menu in one workbook and
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.