How can I show a pop up menu based on the selection in a previous pop up menu?
For example, if "Company" is selected in a pop up menu in C6, then show another pop up menu in C7. if "Bob" is selected in a pop up menu C7, show another pop up menu that contains the talks "Bob" has in C8.
I am trying to create a talk scheduling spreadsheet with different talk outlines for different speakers. I'm not sure if there are any functions or formulas that can accomplish this. Can anyone help?