Forum Discussion

NyulBal's avatar
NyulBal
Copper Contributor
Feb 15, 2024

Dynamic drop-down list

Dear All,

 

I have an Excel file with 2 sheets: one for employees, and another one for trainings:

 

 

 

 

In Employee sheet I have 2 columns to choose from trainings listed in the Trainings sheet.

Each employee have to enroll to 2 trainings. I already have a drop down list under Training1 column, including all available trainings & I would like to create another drop-down under Training2 excluding the one, which has been selected as 1st training. Thus, a specific training could be selected only once per row (employee).
Could you advise a solution to create this dynamic drop-down list?

 

Thank you in advance.

 

 

Resources