How to feed dynamic information to a drop down List (Validation Feature)?

Hey,

my Problem is the following: I have a Excel Sheet that has many fields of information. In addition I allready managed to create Names and Conact those names to cetain colums by means of using the Validation feature. That creates a drop down selection. Now I want another drop down selection seature based on other information. In my case, when selecting the Product, the Part List should be limited to the ones used within that Product. Or When selected the Part, The Part ID List should be reduced to the possible Part_IDs.

I hope this is clear,

thanks for your help in advance,

Kilian

Hi

Have a look here:
http://www.contextures.com/xlDataVal02.html

Andy.

"kscramm" <[email protected]> wrote in
message news:[email protected]...
>
> Hey,
>
> my Problem is the following: I have a Excel Sheet that has many fields
> of information. In addition I allready managed to create Names and
> Conact those names to cetain colums by means of using the Validation
> feature. That creates a drop down selection. Now I want another drop
> down selection seature based on other information. In my case, when
> selecting the Product, the Part List should be limited to the ones used
> within that Product. Or When selected the Part, The Part ID List should
> be reduced to the possible Part_IDs.
>
> I hope this is clear,
>
> thanks for your help in advance,
>
> Kilian
>
>
> --
> kscramm
> ------------------------------------------------------------------------
> kscramm's Profile:
> http://www.excelforum.com/member.php...o&userid=32695
> View this thread: http://www.excelforum.com/showthread...hreadid=527058
>