Conditional Pulldown List???

[lukus2005]

I'm trying to create a material order form where in the 1st column I
would have a pulldown list to choose a category of material (ie:
Piping, Ducting, Fittings, Accessories...) and then my 2nd column
would have another pulldown list of material based on the selected
category.

Each category will have its own pricelist on seperate worksheets.

TIA

 

[Ragdyer]

Start with Debra's page on "Dependant Lists":

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