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


--
kscramm
------------------------------------------------------------------------
kscramm's Profile: http://www.excelforum.com/member.php...o&userid=32695
View this thread: http://www.excelforum.com/showthread...hreadid=527058

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

Hi

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

Andy.

"kscramm" wrote in
message ...

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