| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Dependent Dropdown - one question for Mr. Phillips | Excel Discussion (Misc queries) | |||
| Date Dropdown Question | Excel Discussion (Misc queries) | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| How do I create a dropdown within a dropdown? | Excel Discussion (Misc queries) | |||
| Dropdown list question | Excel Discussion (Misc queries) | |||
Hybrid Mode
