I am new at excel and I use it to make a job sheet for my employees. I have a work sheet open and in column A1 I put in the namse of a job. In column A2 to A6 and column B2 to B6 I put in my employee names that are assigned that job. In column A8 I put in the name of the second job. In column A9 to A12 and column B9 to B12 I put the employee names assigned to that job.
I have a total of 5 jobs set up like I just described. I have tried to set up validation for this, but I found myself duplicating names or I won't assign an employee to a job. Right now I have my list of employees in column E1 to E25 and I am just dragging and dropping them into the cell so I can be sure I use all of them and I don't duplicate, but it isn't very user friendly. Can anyone come up with a way where I will not duplicate names or the name disappears from the list when I used them on a job.
Any help would be appreciated. I am using Excel 2003
I have a total of 5 jobs set up like I just described. I have tried to set up validation for this, but I found myself duplicating names or I won't assign an employee to a job. Right now I have my list of employees in column E1 to E25 and I am just dragging and dropping them into the cell so I can be sure I use all of them and I don't duplicate, but it isn't very user friendly. Can anyone come up with a way where I will not duplicate names or the name disappears from the list when I used them on a job.
Any help would be appreciated. I am using Excel 2003