[TRURASCALZ]

im creating a a form in excel for a company and i need help trying to use dependant lists, for example its a tshirt order form so here is what i need:

Product.......................Size...........................Price
(Dropdown) (Dependant dropdown) (dependant)

Products and sizes need to be on a different single worksheet
Below is the product worksheet and its layout, and i need to create dependant dropdowns based on product selected



do you understand? ive used data validation somewhat can cant get it to work
its a long list of products on another worksheet and the product needs to be the products and the size depends on the product and the price is dependant on the product which changes with the product.

if anyone can help and has good knowlege of excel can you reply or PM (prefer pm) so i can send you the workbook or create a mock up for me and explain whats what.

800 microsoft points in it for someone who can help me and i approve what works.

[x-bot]

[crashnburn]

TRURASCALZ, on 05 November 2011 - 01:01 PM, said:

im creating a a form in excel for a company and i need help trying to use dependant lists, for example its a tshirt order form so here is what i need:

Product.......................Size...........................Price
(Dropdown) (Dependant dropdown) (dependant)

Products and sizes need to be on a different single worksheet
Below is the product worksheet and its layout, and i need to create dependant dropdowns based on product selected



do you understand? ive used data validation somewhat can cant get it to work
its a long list of products on another worksheet and the product needs to be the products and the size depends on the product and the price is dependant on the product which changes with the product.

if anyone can help and has good knowlege of excel can you reply or PM (prefer pm) so i can send you the workbook or create a mock up for me and explain whats what.

800 microsoft points in it for someone who can help me and i approve what works.

It needs a Data Lookup via Formula & Expressions.

I have a few sample Excel files that do something similar. But you'd have to study the formulae a little to get an understanding of how the EXPRESSIONS work and create your own.