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

Thanks for your reply. i downloaded the example you pointed me to. However, the example spreadsheet seems to have the data available in multiple tabs (tables). I would love to filter the data based on 1 table (2 columns, continuing rows) but not sorted... hope what i am saying here makes sense