Is this possible?
On a worksheet called Setup, a selection is made from a drop down in cell B2 to chose the name of a Racing Class.
On a worksheet called Circuits, multiple types of Racing Class are listed in column A, and the Circuits that make up that Racing Class are listed in column B. One Racing Class can have dozens of circuits, so the Racing Class will be listed multiple times in column A. For instance:
ColumnA ColumnB
Class1 Circuit1
Class1 Circuit2
Class1 Circuit3
Class1 Circuit4
Class2 CircuitA
Class2 CircuitB
Class3 CircuitX
Class3 CircuitY
Class3 CircuitZ
etc
On another worksheet called Season, what I want is to have a drop down menu in B3:B42 that contains a list of Circuits for the chosen Racing Class.
Hopefully this makes sense. Any help would be greatly appreciated.
On a worksheet called Setup, a selection is made from a drop down in cell B2 to chose the name of a Racing Class.
On a worksheet called Circuits, multiple types of Racing Class are listed in column A, and the Circuits that make up that Racing Class are listed in column B. One Racing Class can have dozens of circuits, so the Racing Class will be listed multiple times in column A. For instance:
ColumnA ColumnB
Class1 Circuit1
Class1 Circuit2
Class1 Circuit3
Class1 Circuit4
Class2 CircuitA
Class2 CircuitB
Class3 CircuitX
Class3 CircuitY
Class3 CircuitZ
etc
On another worksheet called Season, what I want is to have a drop down menu in B3:B42 that contains a list of Circuits for the chosen Racing Class.
Hopefully this makes sense. Any help would be greatly appreciated.