Hi all,

I have a DropDown item on a sheet which I want to be filled from a table with a criteria. No user form and obviously no Active X
Table (simplified):
Column A: StaffId
Column B: Name
Column C: Active (Y/N)

I wish to fill the DropDown with only active staff (Y) and sorted A-Z of course.

Any help would be very welcome as I have not found any useful resources yet, but still searching...

Regards,
Nikenis