switching out drop down bars

  • Thread starter Thread starter MrBold
  • Start date Start date
M

MrBold

I am building a quote sheet for my employees.
When they select a different product from the "product drop down bar" I want
a new set of colour options to appear in the "colour selection" drop down bar.

What would be the best way to do this?

Thanks
 
Hi,

You didn't tell us how you created the "drop down bars?" It seems that what
you want is for one Data, Validation drop down list to affect the options in
a second Data, Validation list? If so here is the basic idea.

Create the master data validation list. Don't include spaces in the items,
use underscores if you must.
For each of the choices on the master list create sub-list, each in their
own column. Select each of these lists and give them a range name which
matches the items in the master list. You create a range name by clicking
the Name Box on the far left of the Formula Bar. Type in the item name (no
spaces) and press Enter. Repeat this for each list.

Move to the cell where you want the Master list to appear on the data
validation. Choose Data, Validation, List, and in the Source box enter the
range where your master list is located. Let's suppose, for this example,
that is A1.

Move to a cell where you want the appropriate sub lists to show up. Choose
Data, Validation, List, and in the Source box type =INDIRECT(A1).
 
Okay, this works great, except it creats a new problem. I had been using
drop down bars that I could link to a cell. That would give me a number that
I could use in a look up table to grab a price for the calculations.
If I use validation drop down lists how do I link the selection to a hidden
price that I can use in calculations?
 
Back
Top