Complex VBA workbook

Hello there,

I have a complex excel workbook in which my associates would like to make more complex. Right now the workbook has the ability to run through rows and columns and make a chart for those it needs to. We would like to add auto emailing to and associate who is 30 or 90 days away from an expired certification. The issue that I'm having is that there are multiple names and many certifications. I have a limited knowledge with macros and vba but I'm created a simple auto email before. Just not one where it will have to search through so many rows and columns. I will be willing to share the workbook so I can get better guidance but will not put it out for public knowledge. If anyone can help me, I would be truly appreciative.