See one reply at your other post.

"andyp161 <" wrote:

Hi there,

Is it possible to source data validation/dependant lists from a
seperate workshhet within the same workbook. When I try
'=INDIRECT(Sheet2!A2) for example, Excel tells me this is not
possible??

Kind regards

Andy

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson