Hi there,
I am currently working on a performance monitor for work. We currently have set objectives and I have created a document that front line staff input their monthly stats and receive a monthly and YTD rating based on their performance.
What I now want to do is create a managers form that pulls the information together. The managers document will have a 'front page' worksheet that shows the team average for each graded area in each month, and then a tab per team member that has their individual stats and ratings.
Is there anyway to set this up so that if staff change teams they just need to drop their spreadsheet in the new teams folder and the managers document will automatically update.
Or would blank spreadhsheets need to be used for the staff to copy their data into? (I'd rather avoid this as it requires more work and management than a drag and drop)
Thanks
Adam
Bookmarks