Chart needs to auto populate items from master referance chart based on job description.

[gluktar]

Hello.

I have attached the sheet, but here is what i hope it can do.

Certain job descriptions require certain training. Drivers needs these two particular trainings and an office employee only needs that training...

I have a reference sheet with what trainings are required for what job. I then want the next chart with each employee name and subsequent job title to have the required trainings automatically checked. (i can take care of the conditional
formatting after that)

Thanks.

Job Desc.xlsx