ExcelBanter - View Single Post - Excel 2003

Marcelo

thanks Debra

"Debra Dalgleish" escreveu:

You can use a list on a different worksheet, if the list is named, as
described he

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

Marcelo wrote:
Hi Hessen,

sorry but, I think you can't do it. the validation list must be on the same
worksheet.

hth
regards from Brazil
Marcelo

"Hessen_Wraith" escreveu:

I am trying to insert a drop-down list into a cell using Data Validation. The
list is from another workbook. I have followed the instructions given in the
help file, but everytime I work through them I end up with the following
error message:-

"You may not use references to other worksheets or workbooks for Data
Validation criteria!"

This message appears to contradict with the information in the help file.
Can anyone offer some guidance as to where I am going wrong?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html