I have created a tracking chart which uses a drop down menu to assign task to
team members. Now I want to separate each person's tasks onto a separate
sheet using the name in the first sheet to separate the tasks.
Meaning : the items everyone is responsible for go onto the master sheet but
then I can view what I am responsible for if I open my tab(sheet). I guess I
need to know what formula can I use to say if 'Michele' is in E2 then put
that entire line in the next available field on the 'Michele' sheet in the
same work book. I hope that makes sense.