| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list reliant on condition
Hi,
Is there code I can use instead of an entry in a cell to archive the following. I have a drop down list in a cell that is created from the menu item Data, Validation.... and refers to a named range, this range name is defined with a formula that varies on what text is in a particular cell, the formula is: =IF(Menu!$A$1="Adm",Codes!$C$1:$C$30,Codes!$B$1:$B $20). When Adm is in cell A1 my named range refers to Codes!$C$1:$C$30 whereas is A1 is anything else, the name range refers to Codes!$B$1:$B$20. Thanks, Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down based on a condition | Excel Worksheet Functions | |||
| Copying Excel Sheet for data that is reliant on an equation | Excel Discussion (Misc queries) | |||
| making the fill gradiant reliant on another source range | Charts and Charting in Excel | |||
| Sorting or if statements reliant on formatting | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Threaded Mode
