Creating a dynamic dropdown list with Data Validation from another workbook with a little help from Power Query
Creating a dynamic Dropdown List with Data Validation from another workbook with a little help from Power Query