Posted by Andy Gee on December 11, 2001 12:35 AM
I have a columb with 1000+ dropdown boxes stacked above each other, each dropdown needs to get it's content from one of 8 arrays depending on the value of another cell in the row.
Is there a way in which to make a dynamic array reference cell? ie.
=If(A1=1,"D1:D10",If(A1=2,"E1:E10",If(A1=3,"F1:F10",0))) (OR SOMETHING SIMILAR)
Then use this text output to feed into the input range of the dropdown box???
Can dynamic drop down boxes be made? Will I need VB script? I can only edit VB, I have no idea where to start with this though. Any help would be much appreciated.