Excel Data Dependent
Budget: $10 – $30 USD
I need to build a data dependency for several categories through a 3 drop down menus (please see attached).
For example,
Drop Down Field 1 > Its displays (Level 1) items > if I click on Operational > it displays only (Level 2) categories that are relevant to "Operational" > then if I click to "People / HR) it would only displays (Level 3) categories that are relevant to "People / HR".
This applies to the rest of the worksheet. I only need 3 drop down menus to select from for all the data in the spreadsheet. In addition, the solution has to be reliable.
Thanks,
For example,
Drop Down Field 1 > Its displays (Level 1) items > if I click on Operational > it displays only (Level 2) categories that are relevant to "Operational" > then if I click to "People / HR) it would only displays (Level 3) categories that are relevant to "People / HR".
This applies to the rest of the worksheet. I only need 3 drop down menus to select from for all the data in the spreadsheet. In addition, the solution has to be reliable.
Thanks,