In linked thread I posted worksheet where on sheet Report persons are selected depending on previously selected organization. Depending on organization selected, on sheet Hidden a list of persons from this organization is calculated. This list is used as Data Validation source to select person.

https://www.msofficeforums.com/excel...oint-data.html