Hi,
My aim is to have all of my team members putting their output on to one sheet. Which will pull all their performance reports in one place. However, I also need to make it so that they are anonymous in the spreadsheet so that they dont know who is who when they are in the sheet at the same time. Is there a way to either change the colleagues names to a number or make them all anonymous so that they dont know who is entering on the worksheet?
Any assistance would be appreciated.
My aim is to have all of my team members putting their output on to one sheet. Which will pull all their performance reports in one place. However, I also need to make it so that they are anonymous in the spreadsheet so that they dont know who is who when they are in the sheet at the same time. Is there a way to either change the colleagues names to a number or make them all anonymous so that they dont know who is entering on the worksheet?
Any assistance would be appreciated.