Drop Down List

[Steve]

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]

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]

Hi Debra

Thank you

perfect solution!!

Steve

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