I have a list which has an employer id and then employee id's. I need to
list all the employee ID's associated with one empoyer id.

I have a data entry sheet whereby the employer ID is entered; the next entry
is that of the employee ID. What I would like to create a drop down list for
employee ID's that would list all the possible employee Id's for a given
employer ID.

I would like to create a table that would be my list for the drop down box.
If I use a function like Vlookup it only finds the 1st Employee ID associated
with an Employer ID and thus my problem.

How can I create a macro to scroll down the Employer ID and Employee ID list
and populate a table of all the Employee ID's associated with a particular
Employer ID?

Note that I want to avoid cutting and pasting as I know this could be
accomplished via Data sort, etc. I would like some way to automate it.