Hi,
I am trying to compile a stock list document, what I would like to achieve is to have a drop down list which pulls in data from a different tab.
For example, I would like to have a drop down list populated with; apples, bananas, oranges. On another page I will have 3 tables of apples, oranges and bananas, each of those tables has 2 collumns, the first listing the different types of apples and the other listing the amount we have in stock.
When Apples is selected from the drop down list I would like the apples table to pull in to the front page so the stock can be checked and edited, on completion then I can go back to the drop down list, select oranges and then the oranges table ill appear.
The two questions I have is; how do I create a drop down list which is populated with the names of the tables, and then how do I use the drop down list to import the relevant tables upon selection.
I hope this makes sense, any help would be greatly appreciated!
I am trying to compile a stock list document, what I would like to achieve is to have a drop down list which pulls in data from a different tab.
For example, I would like to have a drop down list populated with; apples, bananas, oranges. On another page I will have 3 tables of apples, oranges and bananas, each of those tables has 2 collumns, the first listing the different types of apples and the other listing the amount we have in stock.
When Apples is selected from the drop down list I would like the apples table to pull in to the front page so the stock can be checked and edited, on completion then I can go back to the drop down list, select oranges and then the oranges table ill appear.
The two questions I have is; how do I create a drop down list which is populated with the names of the tables, and then how do I use the drop down list to import the relevant tables upon selection.
I hope this makes sense, any help would be greatly appreciated!
