Quote Originally Posted by davesexcel
Sorry I didn't notice the thread was in worksheet functions

Unhide columns G:H to see the formulas
select E2 to see the formula for your data validation
No problem Dave its the urge to help which is more important....
But unfortunately its not working the intended way.
When I tried selecting Sarah it just displays three options in the drop-down and
What I also want is to get different drop-downs in every Row so beneath E2 in E3 If I select Alice then I need all the tasks Assigned for..so on so forth...