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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mp - 13 Oct 2006 16:02 GMT

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

Reply to this Message

Paul B - 13 Oct 2006 16:18 GMT

mp, use a named range, have a look here for how to do it
http://www.contextures.com/xlDataVal01.html#Name

Signature

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

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

Reply to this Message

mp - 13 Oct 2006 16:29 GMT

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
[quoted text clipped - 7 lines]
> > does anyone know how us a data validation list from another worksheet
> > within the same workbook?

Reply to this Message