Hi
Im hoping someone can point me in the right direction.

Im not sure what its call or how to do it but I need to separate a complete list of staff names, phone numbers, managers and contract hours from a main page to each staff to a tab for each manager in the same workbook. I need that when I add a name to the main page that it then put that name into the tab that is for that manager. For example then names below would be on the main page for quick look up but then they need to be on separate tab for each manager with the contact and contracted hours details so that we are then able to see who is managed by who at a quick glance.
eg


Community Care Worker Phone No Manager Contract Hours
Margaret Smith 0415 021 584 Karen 60
Jane Jhones 0412 658 598 Margret 30
Kim Lane 0148 785 458 Chris 45


Unfortunately I haven't used excel for anything beside basic data recording in a long time and was asked to see if i can work it out.

Thank you for your help in advance for being pointed in the right direction.

Could you possibly upload a file with sample data and examples of the result you expect?

This is just a quick sample. AS you can see each manager has there own tab and the main tab has the list that I need to separate on to each manager tab and as I add a new care worker I need that to automatically appear on the corresponding tab.

Thanks

Attached Files

CCW and Manageres.xlsx (10.5 KB, 7 views)

Take a look at the attached.

Attached Files

CCW and Manageres_2.xlsx (15.8 KB, 7 views)

Maybe I should have mentioned that when defining the name d and the name 'manager' you must reference so big an area that there is enough room for adding new workers.

Thank you I will have a look at what you have suggested and play with it. Thank you again.

Thank you it works and I I have increased the number from 6 to 1000