Hello,
I've been working on a project and hit a snafu, so I'm hoping to get some help.

I am currently populating a ComboBox with 300+ names---list of employees. This list, however, changes over time, and I intended to manually alter it at such time. However, I realized that, for retention purposes, this was not effective. So, my solution is this: I want to create a Combobox that lists all employees that are active. To my original list, I will add a column to indicate status. These statuses may appear as Trainee, CTO, Probation, or Inactive...among others. How can I create a dynamic drop-down that will
A) alphabetize all the items according to the last name and
B) present only those employees whose status is NOT "Inactive"

For simplicity, let's say that Column A is Employee Name and Column B is Status