I am currently working on a project to help efficiently track training due dates for the employees of the company that I work for. I am proficient with Excel, just not the programming side, so this is why I came here looking for help. I am using Excel 2007 BTW.
Okay, the deal is, All I really need to have is 3 columns of data, with A Being the employee name, B being the date trained column, and C being the training due column. Columns B & C will contain only dates.
I am looking for a macro that will run when the workbook is opened, and will display a message highlighting the rows of employees who need training either within the LAST 30 days or the NEXT 30 days.
Also, it would be great if the macro could also contain a button to either publish this list of employees to either an Adobe PDF or Word Document.
Thanks for all of your help, and I hope I am not making this too complicated. lol.