Not sure how to automate the scoreboard here. Any help with the formulas/macros, etc would be great!
1. How can the most recent entry only (for each recruiter/client services person) to reflect on the 2015 scoreboard tab? Is that possible?
2. If we have to add a new sourcer/recruiter/client services tab, how can I ensure the appropriate format, fields, and formulas are created without having to manually redo all the formulas again?
3. Lock the 1st and last tabs (only one person can access the data)?
Please see attached updated file!