how to use a data validation list from another worksheet within the same workbook

[mp]

does anyone know how us a data validation list from another worksheet
within the same workbook?

 

[Paul B]

mp, use a named range, have a look here for how to do it
http://www.contextures.com/xlDataVal01.html#Name
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[mp]

Your tip worked. Thanks!

mp, use a named range, have a look here for how to do it
http://www.contextures.com/xlDataVal01.html#Name
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003