I have a list of mandatory training policies that has to be completed by a whole department, and it is the job of multiple line managers to keep up to date with all the mandatory training. The attached spreadsheet is to be send out to every line manager so that they can input the names of those they manage and fill in compliance. There are 39 mandatory training courses, but only the first five are required by every employee, the rest only apply to select groups, and even select individuals. I have named each of the policies so that they can be easily jumped to, and these can be selected from the drop-down menu above the table. However, what I was hoping to achieve was, upon opening, to have every column hidden except for the first five, as these are required by everybody, then once a policy is selected, the selected column would unhide so that data can be filled in. This would mean that only the policies applicable to that line manager would show, thus making it easier to enter data. I'm not sure if this is possible as I am a bit of a novice to Excel, and I'm not expecting it to work, but if anyone has any idea if this is feasible, and if not could offer an alternative solution, I would greatly appreciate it.
Bookmarks