I have Maintained a Master XL which is linked to another remote XL file and through INDIRECT.EXT function i fetch details from remote XL and load it in Master XL.

In the remote excel file there is a range of data which needs to be queried and a dynamic dropdown needs to be created in Master XL. Pl help

Eg, This is the range data in the remote XL. I need to create a dropdown list in Master XL containing list of Permenant Employees(X & Z in this example).

Employee Status Employee Name
Permenant X
Temporary Y
Permenant Z