Every month I receive data of different employees and where they work. This list will not be the same and will change monthly. I would like to have the first tab on my worksheet be the raw data and then match the employee by the division they work. So there may be 6 employees working "west" division. I want to make a formula that will take all the "west" division employees and autopopulate onto the "west" tab with all the employees information.
I made an example of what I need. I would like the division to be filtered and all the employee info next to the division automatically with a formula. I was thinking possibly an index and match but I'm not sure how to go about it. Right now I copy and paste multiple divisions. I'm hoping this is possible to do.
Thanks for your help.
Index of Employees.xlsx
Bookmarks