So, this is what I want to do:


I have 6 sets of data, I want people to be able to choose which set they see. That's easy, a drop down list will hide the ones they don't want.

I also want them to be able to see up to four instances of the data, and be able to choose each time.

So what I want is one drop down list which says: "How many sets do you want to see: 1,2,3,4", and then, in each visible set, another drop down list which says "choose data set: A,B,C,D,E,F"

Now, I can get these to work, such that within each sub list, rows are hidden or revealed depending on what data set is selected. And the initial list which will show 1 - 4 lists based on what they chose. However, the initial list overrides the sub-lists, so that if you choose "2 sets of data", it then shows you "ABCDEF ABCDEF". Then I can go and select specific sets so that it only shows e.g. "D A" or "A C". How can I make the first drop down list integrate with the others? Can I say something like "Unhide Rows X-Y unless another list has them hidden"?