Basically all I want to do is to manage a spreadsheet of new call center hires.
I just want to have 3 worksheets within this Spreadsheet.
1. One tab with every employee's information (region where they work, job titles, etc.)
2. One tab that breaks out the employees by region of the country they work in.
3. One tab that breaks out the employees by their job titles.
Basically tabs 2 and 3 should be included WITHIN in Tab 1. I'm just trying to avoid having to enter the data in two places every time someone is hired or fired. Ideally I just want to enter the data in tab one and have some formula automatically sort the data into the two additional tabs.
Any help is greatly appreciated. The simpler the solution, the better for my small brain!
Bookmarks