Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Drop-down lists
Hi Suppose I have the following entries in 2 columns in a data sheet 1: Sony Sony 1 Panasonic Panasonic 1 Sanyo Sanyo 4 Sony Sony 2 Sony Sony 3 Panasonic Panasonic 2 Sanyo Sanyo 1 Sanyo Sanyo 2 Sanyo Sanyo 3 Question 1: How do I setup a drop-down field on another sheet 2 so that it only shows me unique options from col A (i.e. only shows three options of Sony, Panasonic, and Sanyo)? Question 2: In sheet 2, after I have selected one of the unique options from the drop-down as above, I want to have a drop-down in the next column that only gives me related options from col B of the datasheet... so if I pick Sony from the first column dd, the only options in this second dd are Sony 1, Sony 2, and Sony 3. How do I do this? I also need the option to add new values in this column if it doesn't already appear in the dd. Thanks in advance Arjay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formulas that return different drop down lists | Excel Discussion (Misc queries) | |||
Setting up conditional drop down lists in Excel 2003? | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Conditional Drop Down Lists | Excel Discussion (Misc queries) | |||
Conditional drop-down lists | Excel Worksheet Functions |