Forum Discussion
NyulBal
Feb 15, 2024Copper Contributor
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 ...
mathetes
Feb 15, 2024Gold Contributor
Attached is one way to do it. This takes advantage of the FILTER function, and that requires either a fairly new Excel or a subscription to Microsoft 365
Here's a YouTube video that explains this use of the FILTER function more fully.