Data validation dropdown list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bernie Simmonds - 24 Jun 2005 22:39 GMT

The Data validation dropdown list appears to need the list of validation
data same work sheet. I would like to have my validation data on a
separate sheet.
Can this be done?

Bernie Simmonds

Reply to this Message

Dave Peterson - 24 Jun 2005 22:52 GMT

If you name the range, you can use that.

See Debra Dalgleish's site for some nice pictures:
http://www.contextures.com/xlDataVal01.html#Name

> The Data validation dropdown list appears to need the list of validation
> data same work sheet. I would like to have my validation data on a
> separate sheet.
> Can this be done?
>
> Bernie Simmonds

Signature

Dave Peterson

Reply to this Message

Bernie Simmonds - 24 Jun 2005 23:05 GMT

Thanks Dave, Bernie

> If you name the range, you can use that.
>
[quoted text clipped - 7 lines]
>>
>>Bernie Simmonds

Reply to this Message