DropDown Question
 

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

--
Best wishes,

Jim

DropDown Question
 

Hi Jim

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jim Jackson" wrote in message ...
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

--
Best wishes,

Jim

DropDown Question
 

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

Jim


"Ron de Bruin" wrote:

Hi Jim

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jim Jackson" wrote in message ...
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

--
Best wishes,

Jim

DropDown Question
 

Hi Jim

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

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

Roger Govier


"Jim Jackson" wrote in message
...
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

--
Best wishes,

Jim