Data validation list from another worksheet?

[puneetarora_12]

Is it possible that the value list for data validation be populated fro
another worksheet?


Puneet Aror

 

[Anne Troy]

Sure is! Use a named range as described here:
http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"puneetarora_12"

 

[puneetarora_12]

Thanks a ton !!

: