Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to create a spreadsheet that looks up options from another sheet and
allows the user to select from a drop down list. However, depending on what option they select in Drop Down 1 (e.g. cell A1), will then only depend on the options available to select from Drop Down 2 (e.g. cell B1). For example: Cell A1 (Quarter), Cell B1 (Month), Cell C1 (Day). If select Quarter 1, then when tabbed to cell B1, the only options are Jan, Feb, Mar, then if Feb selected, cell C1 only options are 1-28 (for example sake). Is this possible? Thank you. Nikki |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List all selections from drop down | Charts and Charting in Excel | |||
Drop down selections and combining fields. | New Users to Excel | |||
multiple selections from drop down list | Excel Worksheet Functions | |||
Multiple selections from a drop down list in Excel... | Excel Worksheet Functions | |||
Multiple selections in a drop down menu | Excel Worksheet Functions |