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 when the last time is that they have done them. not all mechanics work with all brands so i don’t want to have the unnecessary brands on the mechanics tab. 

my idea is that i would have a master data sheet that has every course our manufacturers have available linked to the manufacturers brand name. 

but i would like to know if it would be possible that when i fill in those brand names on the specific mechanics excel tab as his competencies if it could then auto fill that mechanics tab with the manufacturers courses that are applicable to him. 

and secondly it would be amazing if it is possible that it auto updates the mechanics tab if a new course gets added to the master data sheet linked to the manufacturer he/she has as his/her competency, so i do not have to manually update all the different mechanics tabs with the new course.  

below a quick example of the courses tab and a simple mechanics tab to hopefully make it clearer. the courses would auto populate under the available courses. 

​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 when the last time is that they have done them. not all mechanics work with all brands so i don’t want to have the unnecessary brands on the mechanics tab.  my idea is that i would have a master data sheet that has every course our manufacturers have available linked to the manufacturers brand name. but i would like to know if it would be possible that when i fill in those brand names on the specific mechanics excel tab as his competencies if it could then auto fill that mechanics tab with the manufacturers courses that are applicable to him.  and secondly it would be amazing if it is possible that it auto updates the mechanics tab if a new course gets added to the master data sheet linked to the manufacturer he/she has as his/her competency, so i do not have to manually update all the different mechanics tabs with the new course.   below a quick example of the courses tab and a simple mechanics tab to hopefully make it clearer. the courses would auto populate under the available courses.   Read More

​