Data validation dropdown list

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

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

Bernie Simmonds wrote:
>
> 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

--

Dave Peterson

Thanks Dave, Bernie

Dave Peterson wrote:

> 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
>
> Bernie Simmonds wrote:
>
>>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
>
>