Drop Down List

Steve · Jul 21, 2004

Hi All

Can this be done, as I am struggling.

I have data in sheet B and want to create a drop down list in sheet A from
this data, and I can't make it happen, I can create a drop down list in
sheet A from data in sheet A but not from sheet B

Could anyone help please

Cheers

Steve

Debra Dalgleish · Jul 21, 2004

Name the range on the other sheet, and you can refer to it in the data
validation dialog box. There are instructions here:

http://www.contextures.com/xlDataVal01.html

Steve · Jul 21, 2004

Hi Debra

Thank you

perfect solution!!

Steve

Debra Dalgleish said:
Name the range on the other sheet, and you can refer to it in the data
validation dialog box. There are instructions here:

http://www.contextures.com/xlDataVal01.html