Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a drop-down list
I would like to create a drop down with a limited number of choices based on
another cells selection. I have 11 sheets that will need the same formula. I have found examples that create named lists but I am not sure if this is what I want to do. My problem sheets have a "unit type" drop down list (C8) and another sheet "Info" has a list of unit types with a zone column. There are multiple zones for any given unit type. I guess my question is what is the best way to give the user a drop down. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Creating a Drop Down List from a List in another worksheet | Excel Discussion (Misc queries) | |||
creating a drop down list | New Users to Excel | |||
Creating a drop down list | Excel Discussion (Misc queries) | |||
Creating a drop down list | New Users to Excel | |||
Creating a drop down list from another drop down | Excel Discussion (Misc queries) |