Greetings: Help with Generating Monthly Expiration Report

[jeaux]

I am new at excel and have very limited experience. I have a employee training database, with employees (in column A2:A54) and the certification names (in row A1:AS1) that I must generate a monthly report on employees that are expiring within the current month. The cells are already conditionally formatted to change colors for one month prior to expiration date, current month of expiration date, and past the expiration date. I am manually gathering the data then adding it to another sheet. In the mist of trying to gather data, I am missing and/or overlooking information. I wanted to know if there is a way to automatically generate a report based on the expiration dates that would pull the employees name and which certification is expiring or expired, preferable both. I have tried reading threads and applying advanced filters but due to the number of certifications it is not functional to do it this way. I do not know much about writing code but I am willing to learn. Any suggestions would be mighty helpful. I have attached a sample of the spreadsheet. Thanks!mployee Training Database.xlsx

[vlady]

Welcome to the forum.












Note to other mods: Don't move thread. Thanks