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
Bookmarks