Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating formulas using text in the search criteria
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating formulas using text in the search criteria
My first thought from what you said is to use filter on the name and copy
each into their own sheet. But, if I were you, I would review Pivot Tables. You can put all data in one sheet and use the pivot table report to show what you want. Then you can even ask to "show pages" from the pivot toolbar and it will create sheets for each name or whatever. hope this helps "Michele" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Search | Excel Discussion (Misc queries) | |||
Creating Array formulas with multiple criteria | Excel Worksheet Functions | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Creating A Search Database..Need Help | Excel Discussion (Misc queries) | |||
creating a search model | Excel Worksheet Functions |