Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with creating drop down
Hi,,
can anyone help me on how i can create a drop down combination(i'm not sure what it is called)? x y z X1 y1 z1 x2 y2 z2 x3 y3 z3 What im trying to do is if cell A1 has a drop down list(with X,Y,Z selection), i would like cell B1 to return another drop down list that contains a list corresponding to what was selected in cell A1.. so if cell A1 is Y, then cell B2 will show another list with Y1,Y2 and Y3 selection... Im using MS Office 2007. Please advise and thank you very much. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with creating drop down
Hi,
take a look at Debra web has excellent examples http://www.contextures.com/xlDataVal02.html "max007" wrote: Hi,, can anyone help me on how i can create a drop down combination(i'm not sure what it is called)? x y z X1 y1 z1 x2 y2 z2 x3 y3 z3 What im trying to do is if cell A1 has a drop down list(with X,Y,Z selection), i would like cell B1 to return another drop down list that contains a list corresponding to what was selected in cell A1.. so if cell A1 is Y, then cell B2 will show another list with Y1,Y2 and Y3 selection... Im using MS Office 2007. Please advise and thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
creating drop boxes help | Setting up and Configuration of Excel | |||
Creating a drop down list from another drop down | Excel Discussion (Misc queries) | |||
Creating a drop-down menu | Excel Programming | |||
Creating a drop-down menu | Excel Programming |