Drop Downs

VAL1133

New Member
Joined
Dec 8, 2005
Messages
2
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.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

NathanPage

New Member
Joined
Dec 8, 2005
Messages
9
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,038
Messages
5,569,801
Members
412,293
Latest member
RJSCHILLER
Top