Need help with generating 3 reports from one file

Dear All,
Greetings! This is my first post here and I will admit am a total novice with excel as far as macro or vba and all the other high end stuff is concerned. Please take a look at the attached spreadsheet. I need help in generating the below 3 results/reports from the attached file. Would it be possible to run an exception report that would return the below three results/reports.

• An exception report that reflects those candidates that are missing training.
• An exception report to reflect those positions that are missing the mandatory training for the positions listed on the REQUIREMENTS tab. The REQUIREMENTS tab reflects the list of positions if mandatory training is required or not.
• Would it be possible to format the names in such a way so that the name turns red in colour a month before his training expires? The validity of the training is mentioned under the REQUIREMENTS tab against the names in the first row.

Any help will be greatly appreciated, thank you so very much.
Kind regards,

Jan

Dear Arlette,
I need to get this info, but dont know how and will need help in automating it. Basically the end result has to be an automated report with the three results. I am not sure how cause I do not have any other excel skill besides the basics. Thank you very much for taking the time and looking into my file, much appreciated.
kind regards,
Jan

Many thanks FDibbins. This is indeed the first step.
-The training Muster list will be the primary tab that will be updated constantly to reflect new crew that join as and when, new certificates issued and so on. All that will be entered manual in this tab is the name, employee id, position and the date the certificate was issued.
-The date inserted into the cell for each candidate will reflect the validity of the certificate and the validity of the certificates are in the requirement tab. So this narrows down to two results
1.[I] Report that tells me which candidate is missing the mandatory training.
2. Report that gives me the names of the candidates whose certificates will expire one month in advance before the actual expiry of the certificate. Could this be made automatic on the training muster tab itself where the name will turn red in colour a month before his certificate expires?[/I]-The requirement tab will pretty much stay the same, it will only be updated if there is a change in the validity of the certificate or a new training, requirement or positions added.


Kind regards,

Jan

Many thanks FDibbins. This is indeed the first step.
-The training Muster list will be the primary tab that will be updated constantly to reflect new crew that join as and when, new certificates issued and so on. All that will be entered manual in this tab is the name, employee id, position and the date the certificate was issued.
-The date inserted into the cell for each candidate will reflect the validity of the certificate and the validity of the certificates are in the requirement tab. So this narrows down to two results
1.[I] Report that tells me which candidate is missing the mandatory training.
2. Report that gives me the names of the candidates whose certificates will expire one month in advance before the actual expiry of the certificate. Could this be made automatic on the training muster tab itself where the name will turn red in colour a month before his certificate expires?[/I]-The requirement tab will pretty much stay the same, it will only be updated if there is a change in the validity of the certificate or a new training, requirement or positions added.


Kind regards,

Jan