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

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:

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

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

"Marcelo" wrote:

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:

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