Hi,
I have made a spreadsheet test, that contains some test data in a 3 tier drop down system. I was just wondering if it would be possible for me to create two option boxes that regulate what goes in. For example, in the test sheet that i have attached, could i have an option box called "Data set 1" and "Data set 2", and when data set 2 option box is pressed the drop downs will contain the data from the page "Data 2" and the "Data set 1" option box would correspond to the first pages data.
Any help is appreciated, if you could give me an idea of how to do it. Thanks.
Bookmarks