Use Combo to populate cell values

I am trying to create a worksheet that will allow the user to select an employee name for a list and add that value to corresponding cell.  Then go to next row and select another name.

I tried both Form control and activex control but, they only populate 1 cell.

Can someone point me to the correct directions that allow to update multiple rows of data based on a list box in column A?

thanks,

K