View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikki Nakki Noo Nikki Nakki Noo is offline
external usenet poster
 
Posts: 1
Default Drop Down Selections - Linked

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