Hi all,
I looked through other threads but nothing helped with my situation.
I have a spreadsheet with employee names (LAST, FIRST, MI) in columns A,B,C then a list of the specific licenses and certifications continuing out to column R currently, with the potential to go further depending on additional certifications that come in. Those headings (names, license, cert types) are all in Row 9. I would like to get a pop up notification / msg box when opening the spreadsheet when there are dates that are 60 days from expiration. Ideally I would like the pop up to include the license type (so row 9 of the respective column with expirations) along with the last name of the employee whose license is expiring (column A of the respective Row, e.g. "Smith CPR Certification expiring in 60 days".
Not all the data in the field will have dates. Some certifications do not have expirations so they are denoted with an 'X' to show they obtained the certification. Not sure if that makes a difference. Also, would making this into a table affect the VBA? I would like to make it slightly easier on the eyes. Thanks in advance!
I looked through other threads but nothing helped with my situation.
I have a spreadsheet with employee names (LAST, FIRST, MI) in columns A,B,C then a list of the specific licenses and certifications continuing out to column R currently, with the potential to go further depending on additional certifications that come in. Those headings (names, license, cert types) are all in Row 9. I would like to get a pop up notification / msg box when opening the spreadsheet when there are dates that are 60 days from expiration. Ideally I would like the pop up to include the license type (so row 9 of the respective column with expirations) along with the last name of the employee whose license is expiring (column A of the respective Row, e.g. "Smith CPR Certification expiring in 60 days".
Not all the data in the field will have dates. Some certifications do not have expirations so they are denoted with an 'X' to show they obtained the certification. Not sure if that makes a difference. Also, would making this into a table affect the VBA? I would like to make it slightly easier on the eyes. Thanks in advance!