Stumped on whether or not this is possible, so I'd appreciate any support.
I have an excel file with two sheets. "Master Employee List" shows the employee name in Column A and one of three possible managers assigned to them in Column B. Very simple.
I'm looking to have the next sheet, "Teams" automatically organize teams in a column format, based on what manager is assigned to them. I want to make it so that whatever Manager I assigned, the "Teams" sheet updates on its own.
I've attached the spreadsheet to this thread. Curious if this is possible and thanks in advance!
Bookmarks