Forum Discussion
auto populate excel tab with training opportunities
Hi, My manager has asked me to look into streamlining our excel document that is meant to track our mechanics competencies and also keep track of which manufacturers courses they have done and w...
It is quite possible to build a list of relevant courses dynamically. There is a catch though. If you expected to use the individual sheets to maintain the record of courses attended, you need to bear in mind that the manual input will not adjust as the list changes.
The changes you could make on the master sheet would be limited to appending a course; any deletions, insertions or re-sorting would create a mess.