Hi,
I have a problem with an Excel spreadsheet that I can not set properly, I'll explain the problem.
I have the need to place inside a drop-down list the list of some stores, and for each of these, I have the need to show the list of available products.
In an Excel spreadsheet I set the drop-down but now I can not connect the values of this drop-down (eg. store_1, store_2, etc.) with the list of available products.
I thought I put into another excel sheet a table thus formed:
STORE_1 STORE_2 pen_1 pen_4 pen_2 pen_5 pen_3 pen_6
but then I do not know how to link the value of the drop-down (eg. store_1) with the display of products (eg. pen_1, pen_2, pen_3).
The idea is to have in the same sheet where it is called the drop-down a set of rows where to show the list of products according to your choice in the drop-down.
Can you help me?
Bookmarks