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
>