Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown List within a dropdown
Good Afternoon Everyone!
I only have 23 hairs left on my head and cannot afford to lose any more. Thus, I ask for your thoughts. I'm in the process of creating a spreadsheet containing many dropdown lists. My need is to create a dropdown within the dropdown, based upon the entry chosen by the first drop down selection. Totally confused yet? For example, if I select "Modem" from the first dropdown. I want to then be taken to another dropdown containing the names of all Modem Manufacturers from which the next selection would be made. In advance, thanks! Jeff Hennessey (down to 22 hairs now....) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown List within a dropdown
On Apr 10, 8:18 pm, Henn9660
wrote: Good Afternoon Everyone! I only have 23 hairs left on my head and cannot afford to lose any more. Thus, I ask for your thoughts. I'm in the process of creating a spreadsheet containing many dropdown lists. My need is to create a dropdown within the dropdown, based upon the entry chosen by the first drop down selection. Totally confused yet? For example, if I select "Modem" from the first dropdown. I want to then be taken to another dropdown containing the names of all Modem Manufacturers from which the next selection would be made. In advance, thanks! Jeff Hennessey (down to 22 hairs now....) I suppose you alreade have a list containing modem manufactures, so all you need to do is make it a names range. Then in your list criteria type = Modem. You'll need a list for each kind of device one can choose in the first dropdown. Per Erik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
Dropdown List.... | Excel Discussion (Misc queries) |