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

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

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<lukus2005@gmail.com> wrote in message
news:3d8a2bff-4c5f-4c49-9480-aa1c245edc38@k30g2000hse.googlegroups.com...
> 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