Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop-down list
I am trying to have two drop-down list linked
E.g. Col:A Col:B Yellow 1 Yellow 2 Blue 6 Blue 7 One drop-down list shows all in ColA Then Next Drop-Down list shows ColB = to ColA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop-down list
Hi Lloyd.
I assume that you mean the content of the second drop down list is dependant of the first and that you are using data validation. This can be done by using the INDIRECT function and creating some named ranges. The named range "Colours" will have two cells containg "Yellow" and "Blue" respectively. Set data validation in column A to address the list contained in "Colours" In A2 select Yellow from the drop down list provided by data validation. The named range "Yellow" will have two cells containing the values 1 and 2 respectively. The name range "Blue" will have two cells containing the values 6 and 7 respectively. Set data validation in column B by 1 Set Allow to list 2 In Source type =INDIRECT(A2) ensure that $ signs are removed by pressing F4 three times. 3 Click OK. Data validation in the validated range in B will change according to the selection in A. I hope this helps. Regards Phil "Lloyd" wrote: I am trying to have two drop-down list linked E.g. Col:A Col:B Yellow 1 Yellow 2 Blue 6 Blue 7 One drop-down list shows all in ColA Then Next Drop-Down list shows ColB = to ColA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop-down list
Hi Lloyd.
Follow the link below, this gives a better explaination than mine and provides a sample worksheet. http://www.contextures.com/xlDataVal02.html Regards Phil "Lloyd" wrote: I am trying to have two drop-down list linked E.g. Col:A Col:B Yellow 1 Yellow 2 Blue 6 Blue 7 One drop-down list shows all in ColA Then Next Drop-Down list shows ColB = to ColA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |