Hi, what i'm looking for is very similar to this thread: http://www.excelforum.com/excel-prog...piry-date.html
EDIT: my latest code and spreadsheet are on post #9
Basically, we keep a spreadsheet of our contractors/subcontractors on file so that we can make sure that we aren't contracting with someone that either 1. doesn't have a business license, or 2. lets their insurance / business license expire.
i've attached a 'dumbed-down' version of my spreadsheet with actual expiration dates, my question is;
to remain compliant, we need to make sure that all of our contractors'/subcontractors' insurance/business licenses are current... what I'm thinking is a set of 'buttons' to run the report for a couple different things, OR 1 button to do everything. Basically, if a discrepancy is found (which would be determined if today's date is within X amount or past the date in a given cell), it would either display that information on a [separate] sheet or shoot an email to the master contractor or an email specified in a cell.. now these spreadsheets are always changing, we lose/gain new contractors constantly..
the email or list of discrepancies would have to include the entire row and possibly the header row so that the person viewing it would be able to see what the expiration dates are for..
is this possible? the reason i'm working on this is because a friend of mine is responsible for notifying the appropriate people of upcoming expirations and lately, she hasn't been able to keep up so I want to make sure her job is secure..
Bookmarks