sex and drop down options

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mt - 27 Mar 2008 02:52 GMT

i want to have two drop down lists in my spreadsheet.
When i select an option on the first drop down list i want the second drop
down list options to change accordingly. e.g. if i choose breakfast on the
first drop down i want "cereal", "toast" etc to appear as options on the
second drop down list, but if i select "dinner" on the first i want the
second to offer "steak", "salad" etc. How do i do this?

thanks

Reply to this Message

Pete_UK - 27 Mar 2008 02:58 GMT

Take a look here:

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete

> i want to have two drop down lists in my spreadsheet.
> When i select an option on the first drop down list i want the second drop
[quoted text clipped - 4 lines]
>
> thanks

Reply to this Message

Dave Peterson - 27 Mar 2008 14:41 GMT

Oops. Should have scrolled down!

> Take a look here:
>
[quoted text clipped - 12 lines]
> >
> > thanks

Signature

Dave Peterson

Reply to this Message

Pete_UK - 27 Mar 2008 14:46 GMT

That's okay, Dave - Debra responded directly to the OP in a duplicate
posting.

Pete

> Oops. Should have scrolled down!
>
[quoted text clipped - 20 lines]
>
> - Show quoted text -

Reply to this Message

Dave Peterson - 27 Mar 2008 14:41 GMT

Maybe you could use Data|Validation and use dependent lists.

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html

> i want to have two drop down lists in my spreadsheet.
> When i select an option on the first drop down list i want the second drop
[quoted text clipped - 4 lines]
>
> thanks

Signature

Dave Peterson

Reply to this Message