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?