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
>
>