Is the price of the material a variable? If not, why would you want a drop
down box for the price of the material. Once you bring over the material, you
could do a VLOOKUP or something in regards to the price.
--
John C


"Vasu" wrote:

Hey All,

I need help with linking drop down boxes.
I have created a drop down box for materials and another one for the price
of material. What I would like to happen is when I select the material the
drop down for the price of material should only show the price for that
material. Can somebody please help me implement this, I am currently using
Office 2003.

Thanks
Vasu