Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link 2 drop down list together?
Hi,
I have created 2 drop down list but I want to link them together so that one list can auto generate its result based on the other list. For e.g. I created a column 'Completed?' and in its drop down it has these following items: - Yes - No - In progress The 2nd column is 'Resolved?' and in its drop down it has these following items: - Yes - No If I select 'Yes' on the second list which is on the 'Resolved?' column, I want the first list which is on the 'Completed?'column to auto-generate to 'Yes'. Can this be done? Can someone show me how? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link 2 drop down list together?
Debra Dalgleish shows how to set up dependent drop-downs he
http://www.contextures.com/xlDataVal02.html Hope this helps. Pete On Sep 3, 6:57*am, hasmah wrote: Hi, I have created 2 drop down list but I want to link them together so that one list can auto generate its result based on the other list. For e.g. *I created a column 'Completed?' and in its drop down it has these following items: - Yes - No - In progress The 2nd column is 'Resolved?' and in its drop down it has these following items: - Yes - No If I select 'Yes' on the second list which is on the 'Resolved?' column, I want the first list which is on the 'Completed?'column to auto-generate to 'Yes'. Can this be done? Can someone show me how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link from a drop down list | Excel Worksheet Functions | |||
How do I link a drop down list to other worksheets | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
How to link data from one drop-down list to another | Excel Worksheet Functions | |||
link to result from drop down list | Links and Linking in Excel |