Multiple Combo Boxes

[squallxgamer]

I have a list of staff and under those staff a number of tasks. I would like to add a drop down so that I may choose the task. I not sure if this is the best route or not but I thought I would throw up and ask what you guys thought the best way to do it was. Who is assigned the task changes on a nightly bases.

 

[squallxgamer]

 

[Legacy 143009]

	A	B
1	JOHN	MICHAEL
2	TASKA	TASK D
3	TASKB	TASK E
4	TASKC	TASK F

<tbody>
</tbody>

1. First make a table like this.
2. Now select "TASK A" to "TASK C". Right click, name cells as "JOHN". Then select "TASK A" to "TASK C". Right click, name cells as "MICHAEL".
3. Select cell C1. Go to "Data" tab. Click "Data Validation". In the little window there is a dropdown. Select "List". List source "$A$1:$B$1".
4. Select cell C2. Go to "Data" tab. Click "Data Validation". In the little window there is a dropdown. Select "List". List source "=INDIRECT($C$1)".

This should give you an idea. You can modify all these according to your scenario. Have a nice day!

 

[Legacy 143009]

2. Now select "TASK A" to "TASK C". Right click, name cells as "JOHN". Then select "TASK D" to "TASK F". Right click, name cells as "MICHAEL".

Sorry

 

[squallxgamer]

So I decided to you data validation drop down list. Is there a way in the code to make sure that no two drop downs are the same?

thank for the reply