I am looking for a non-VBA solution to create cascading drop-down lists. Here is a sample table:
COLUMN A COLUMN B
Exec Management Senior Producer
Exec Management Associate Producer 1
Exec Management Associate Producer 2
Prod Management Scenic Designer
Prod Management Sound Designer
Prod Management Lighting Designer
In the first drop-down list, I would like for the drop-down to return only unique references from Column A. In the second drop-down list, I would like to return Column B items that correspond to the unique criteria selected from column A.
I need to be able to run this out by a factor of three to five levels.
Thanks in advance for your support.
Start Free Trial
