Linking Drop Down Boxes

[Vasu]

Hey All,

I want to create a drop down link that links 4 cells. I have four columns
one for material, then material code,the spesfic material name, and then
cost. I would like to link as such, first i choose my material (eg. Vinyl or
Polyester), this wil limit me to some material code, once i choose my
material code it will show me the name of material, and it will show me the
cost of in the next column

For exaple:
Material -- Code --------Name------------------------Cost
Vinyl ----- 7045 ---3.2 ml matte white --------$0.0014503

I have gotten the Material and Code drop downs to work however I have
problems with getting the Name and Cost.

Can someone please tell me if this is possible and if so how?

Thank You
Vasu Sharma

 

[Marcelo]

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

Debra Dalgleish, has a fantastic solotion for it using data validation.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Vasu" escreveu:

 

[Vasu]

I am a beginner to this, I'm trying to follow the steps but everything is
going over my head. I'm trying to understand what they are doing for the
dynmaic data validation