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 - 26 May 2008 17:56 GMT
Start with Debra's page on "Dependant Lists":
http://www.contextures.com/xlDataVal02.html

Signature
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> 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:
[quoted text clipped - 5 lines]
>
> TIA