Trying to determine the best way to accomplish the following in an excel 2010 worksheet
I have a employeeid and employee name combination for about 20 Employees
I would like to have the employee name in a data validation
Is there a way to pick the name and have it go in to say cell A2 and have the id go into cell a3????
I'm open to any option