How do I link 2 drop down list together?

H

hasmah

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Excel Excel: How do I put a formula in a drop down list 11
drop down list should remember selection. 6
please help (drop down list) 1
drop down lists 2
Drop-Down List 3
drop down list based on other drop down list pick 1
produce list automatically from choice of drop down list 1

Top