I am creating a workbook that contains information for all the employees in our company. The 2 departments are production and performers and we would like the head of each department to be able to look at their employees information (and edit/rearrange to their suiting) and not have to see the other department. The thought is to have a main worksheet that has everyones information and then one for each of the 2 departments. The big problem is how to link them together so the information gets populated on each appropriate page and everyone can arrange the data to their hearts content.
Any thoughts would be greatly appreciated.
Thank you!
Bookmarks