DropDown Question

[Jim Jackson]

In excel is I possible to control what is available in a drop down based on
the value of another cell?



Example

If I select EUR in Cell A1 I want the selections available in cell b2 to be
1 or 2

If I select GBP in Cell A1 I want the selections available in cell b2 to be
1 or 4

 

[Ron de Bruin]

Hi Jim

See
http://www.contextures.com/xlDataVal02.html

 

[Jim Jackson]

Thanks, Ron. This is perfect.
--
Best wishes,

Jim

Hi Jim

See
http://www.contextures.com/xlDataVal02.html

 

[Roger Govier]

Hi Jim

Yes.
For a detailed description go to Debra Dalgleish's site

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