Validation > List Question

[JohnSearcy]

I'm adding a drop down (list) to several cells on a sheet and I have tried to put a list in the source area from another sheet within the workbook several ways including this form

=sheet2!$A$1:$A$10 (as an example)

which won't let me. I'm sure it's simple, but how can you use a list from another sheet within the same workbook?

Thanks,
John

 

[Taul]

use a named range (ie donkey) for the sourse list and in the refers to box in validation use =donkey

 

[Taul]

this may also help
http://www.contextures.com/xldataval01.html

 

[JohnSearcy]

Thank you, Paul.