Hi guys,
i would like suggestion on what is the best way.
The list has 5000+ staffs, with 50+ departments
1) Department Heads need to verify individual staff of their access.
2) Individual department should not see staffs that is not from their department
3) One excel file is used to send out for all department to fill up and collate.
4) this excel file can be upload to sharepoint for them to fill up by a given URL.
5) The department should only see the department staffs, AND also those who have access to their department but not their staffs.
e.g. for "A", i should see staff no. 1,2,3,4, and 12. But not others.
What is the best method so that i did not need to separate their department into different tabs/excels, at the same time, not able for them to see other departments details?
So that when all departments has input, i can just unlock / unhide and the collated list is completed, without combining individual tabs / excel again from various department.
Sample as below
Bookmarks