As a translator, I have worksheets on which I manage my translation projects. In those worksheets, one cell is dedicated to my client's name. Another cell is for the initials of the project manager for the current project. Each client has more than one project manager. Currently I have to manually select the client's name from a drop list (which values are from a range of cells in another worksheet) and the PM's name from another drop list (which values are also from another range of cells in another worksheet).
I would like that the second list (PMs' one) would be dynamically populated depending on the client's name selected in the first drop list.
How can I achieve this?
Many thanks in advance for any helpful answer.