List from Data Validation

[Pauljj]

Is it possible to Index a range from a sheet NOT on the workbook, you are to use the drop down list on ??

 

[Andrew Poulsom]

Could you rephrase your question please? It's not very clear, at least to me.

 

[Oaktree]

Yes, if you use named ranges.

Define a named range to refer to '[other workbook.xls]sheet name'!range

and use that named range as the source for your data validation list.

 

[Pauljj]

Thanks for your reply, when I try this it says it cannot use references to other worksheets or workbooks for Data Validation Criteria ??

 

[Andrew Poulsom]

Did you name the range, eg List, and use =List as the Source for Data Validation?