Drop list affected by previous choice

Hello,

I am using Excel 2004 for Mac and need help on drop lists. I want to change
the drop list depending on the previous choice. Lets say in the first list I
give the choice between 3 options (jumper, pigtail or duplex). Depending on
the choice taken, there would be another drop list that will vary. For the
jumper I have options A, B or C. For the pigtail I have options D, E or F
and for the duplex, I have options G, H or J.

Can someone help me on this issue?

Thanks,

Gaetan

Here's a method

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Ga ë tan Mongeon" <[email protected]> wrote in message
news:BEE31031.19A0%[email protected]...
> Hello,
>
> I am using Excel 2004 for Mac and need help on drop lists. I want to
> change
> the drop list depending on the previous choice. Lets say in the first list
> I
> give the choice between 3 options (jumper, pigtail or duplex). Depending
> on
> the choice taken, there would be another drop list that will vary. For the
> jumper I have options A, B or C. For the pigtail I have options D, E or F
> and for the duplex, I have options G, H or J.
>
> Can someone help me on this issue?
>
> Thanks,
>
> Gaetan
>

Thank you

On 6/25/05 3:13 PM, in article [email protected], "Peo
Sjoblom" <[email protected]> wrote:

> Here's a method
>
> http://www.contextures.com/xlDataVal02.html