dependent drop down list with autofill

I am trying to create a name badge template. On the 'data. page company names are entered in A9:49. in C8:C48 the company names are automatically populate as column headers, allowing input of employee names in the associated columns. for example:

Company1 is entered into A9, it automatically populates C8. Employees for Company1 are then entered into C9:C49.


Here's my challenge. on the following page '1-8' a drop down is available to select a company. Once the drop down is selected the drop down for the employee is has teh associated people available for selection.

I would like to be able to set up both the employer and the employee to autofill once a couple of letters for the company or employee name are typed in. I have attached the file that i have created so far.