I'm need help developing an order form.

We offer multiple styles of shirts and each style comes in different colors.

Right now I have a drop down box in which the customer can select the model
of shirt they want.

On the from form below I need the drop down box to list only the colors
available for the model they selected.

I have a hidden "data" worksheet which has the available colors listed for
each style.

If I know what style of shirt the customer wants, I've been manually enter
the data validation to pull colors for the shirt in the order form below.

I'm hoping for a way in which the colors on the order from are automatically
updated when customer selects jersey style from above.

I really apprecaite anyones time and help.






On Main page I have a drop down menu from which user picks which model of
soccer jersey they want.

On my "data" worksheet

I believe you will find a good walk-through at:
http://www.contextures.com/xldataval02.html

HTH,
Keith

"Soccer Guy" wrote:

I'm need help developing an order form.

We offer multiple styles of shirts and each style comes in different colors.

Right now I have a drop down box in which the customer can select the model
of shirt they want.

On the from form below I need the drop down box to list only the colors
available for the model they selected.

I have a hidden "data" worksheet which has the available colors listed for
each style.

If I know what style of shirt the customer wants, I've been manually enter
the data validation to pull colors for the shirt in the order form below.

I'm hoping for a way in which the colors on the order from are automatically
updated when customer selects jersey style from above.

I really apprecaite anyones time and help.






On Main page I have a drop down menu from which user picks which model of
soccer jersey they want.

On my "data" worksheet

Thank you.


"ker_01" wrote:

I believe you will find a good walk-through at:
http://www.contextures.com/xldataval02.html

HTH,
Keith

"Soccer Guy" wrote:

I'm need help developing an order form.

We offer multiple styles of shirts and each style comes in different colors.

Right now I have a drop down box in which the customer can select the model
of shirt they want.

On the from form below I need the drop down box to list only the colors
available for the model they selected.

I have a hidden "data" worksheet which has the available colors listed for
each style.

If I know what style of shirt the customer wants, I've been manually enter
the data validation to pull colors for the shirt in the order form below.

I'm hoping for a way in which the colors on the order from are automatically
updated when customer selects jersey style from above.

I really apprecaite anyones time and help.






On Main page I have a drop down menu from which user picks which model of
soccer jersey they want.

On my "data" worksheet