My team has a personnel schedule that manages about 90 people across 9 work centers (8 primary and 1 filled by members of the other work centers).
I had a macro that would hide all the team members not included in work center 9 which allowed for those team members to be populate their schedule, then the macro would unhide all personnel allowing the primary work center supervisors to track their personnel within their work center fulfilling duties in work center 9. Basically the members need to be listed under their primary work center but the manager of the 9th work center needs to be able to easily populate the schedule for each of their team members as well.
My employer will no longer allow the use of macros as a result of the security concerns (someone placing a virus or malware in the macro).
1) Is there a mirror formula that will carry formatting (conditional)/text input/comments etc?
So we would have work center 9 personnel in their primary workcenters but mirror their schedule in another sheet?
2) Is there a search function that could be used to pull the workers and the rows associated with their schedule?
In the attachment sheet 1 shows the employees under their primary work centers and sheet 2 shows only them under work center 9. The idea would be to populate these members on sheet 2 and have it populate their blocks on sheet 1. Or run a search function that only displayed the workcenter 9 members.
I already looked into tables with filters but that doesn't work with the merged cells we use.
TIA