Many combo in cells? Explaned below 1

[marcq]

Hello.
I wonder if it is possible to do following issue:
I have two columns with list of Firstname Surname in one Sheet of excel.
Firstname Surname
John Smyth1
John Smyth2
Now I have second shift where I want to assign tasks to them like
Task1 - John Smyth1
Task2 - John Smyth1
Task3 - John Smyth2
etc.
Every time I put new task in new line I'd like to have combo box which will allow to choice from names list in other shift. Is it possible? I know how to put combo box but it is not alligned to row etc.
Any tip?

 

[combo]

You can use data validation lists.

combo

 

[marcq]

Hi. I found the solution Drop down box.
Thanx.