Data Validation from different worksheets

[RichieF]

Is it possible to set up a data validation drop down list using a range of data on a different worksheet ?

I can only seem to get it to work if the data range I wish to use is on the same sheet as the validated cells.

Thanks.

 

[dov]

it will work if you use names for the range with the list

 

[RichieF]

Sorry, i've tried naming the range of cells containing my list, but when I try to point the validation to that range I get a message advising me that I cannot use a range on a different worksheet or workbook.

Thanks for the attempt though...any other suggestions I can try ??

 

[dov]

i doesn't work with names from other workbooks but it worked for me with names from other worksheets in the same workbook.
in the validation windows put = before the name of the source list

 

[RichieF]

Nice one, I was including the fine name as well as the cell reference, hence the problem.

Thanks for your help.

 

[RichieF]

Nice one, I was including the file name as well as the cell reference, hence the problem.

Thanks for your help.