Drop Downs

[VAL1133]

I have a spreadsheet for ordering products coming from both the US and Canada.

On my spreadsheet, I have a dropdown where you select either US or CAN.
On the spreadsheet, I have dropdowns where you select the product you want to order.
On a tab behind the spreadsheet, I have two lists of products with pricing--one for US and one for CAN.

When you select US from the spreadsheet, I want the dropdowns to go to the list of US products and display them in the section where you select the products and pricing you are ordering. Also, when you select CAN, I want the seftion where you select the products to display the Canadian products.

I don't know how to do this. I know how to create the dropdowns--I just don't know how to make it switch for US to CAN lists.

 

[Aladin Akyurek]

See: http://www.mrexcel.com/board2/viewtopic.php?p=154

 

[NathanPage]

The link given by Aladin works nicely. However, if you're a glutton for punishment and insist on doing it with dropdowns...

On a (non-visible) sheet, store the lists for the US and CAN products separately. Then, have a third list containing a series of IF statements- if the choice from the first dropdown is "US", then select items from the US Product list, otherwise from the second.

Link your second Dropdown to the third list.

If I've understood you correctly, that should work.

 

[VAL1133]

Thanks for your help. It worked just the way I needed it to.