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.
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.