I am using an excel spreadsheet to record skill competencies of staff. Sheet 1 will act as a "master" sheet reflecting the skill competencies of all staff (ie different employee in each column) and sheets 1,2,3,4 etc will be used for smaller groups of staff (departments).
I am using Red - no competency, Orange - limited competency, Green - competent as colour codes next to each skill, to indicate where each staff member is at.
If I change the colour on one of the department spreadsheets (for example, sheet 2), how can I get it to automatically update the colour on the master spreadsheet (sheet 1)
Help! THanks :)