I'm trying to use a dropdown box that after choosing will create choices for
dropdown box 2.
box 1:
1
2
3
box 2:
1 orange
1 blue
1 green
2 yellow
2 purple
2 black
3 etc etc etc
Any idea?
thanks in advance, greg
I'm trying to use a dropdown box that after choosing will create choices for
dropdown box 2.
box 1:
1
2
3
box 2:
1 orange
1 blue
1 green
2 yellow
2 purple
2 black
3 etc etc etc
Any idea?
thanks in advance, greg
Hi
Have a look here:
http://www.contextures.com/xlDataVal02.html
--
Andy.
"Greg" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to use a dropdown box that after choosing will create choices
> for
> dropdown box 2.
> box 1:
> 1
> 2
> 3
> box 2:
> 1 orange
> 1 blue
> 1 green
> 2 yellow
> 2 purple
> 2 black
> 3 etc etc etc
>
> Any idea?
> thanks in advance, greg
Hi Greg
Create named lists of the vairous drop-downs you want.
Do a data validation, and in the Source, do ifs
=if($A$1="XXX",LIST1,if($A$1=YYY,LIST2,ERROR)) etc
Cheers
Louis
"Greg" wrote:
> I'm trying to use a dropdown box that after choosing will create choices for
> dropdown box 2.
> box 1:
> 1
> 2
> 3
> box 2:
> 1 orange
> 1 blue
> 1 green
> 2 yellow
> 2 purple
> 2 black
> 3 etc etc etc
>
> Any idea?
> thanks in advance, greg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks