Excel Spreadsheet -- 2

This spreadsheet tracks weekly compliance for patients participating in a clinical trial. There are already formulas written within the excel file. We would like to add a VBA written that scans the spreadsheet and sends a repot based on the number of events that populate under the columns that state "event" Example as follow using the tab "Datacount pivotal" row 3 Column "S" window opens on 3/3/2020 and closes on column "V" 3/10/2020. If the event reflects "0" the spreadsheet will send an email notifying that there is only one day remaining before the window closes. If possible it will send out another spreadsheet in an email with all of the patients that have windows approaching a close and reflect a "0". Further details can be provided via zoom call.