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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Drop-down lists
G'day Arjay
Check out this site: http://www.contextures.com/xlDataVal02.html Download the sample file, I used it on a spreadsheet at work & it works fine. Follow the instructions HTH Mark. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Drop-down lists
Hello I thought I found a way of avoiding this problem but no such luck. Hence further questions. My source data is based around a large number of variables, i.e. I have over 600 manufacturers with some offering more than 400 products. Given this, can Excel handle my request as the Contextures site requires you to lay out all of the data in a pivot format so you can name each range? Or is there an easier VBA way? And given the manufacturers appear multiple times, how do I create a single entry list for the primary DD list in the first place? Hope this makes sense Thanks, Arjay "NoodNutt" wrote: G'day Arjay Check out this site: http://www.contextures.com/xlDataVal02.html Download the sample file, I used it on a spreadsheet at work & it works fine. Follow the instructions HTH Mark. |
Reply |
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 |