This project is for clinical research which tracks the amount of transmissions a patient sends on a monthly basis. A patient is required to transmit twice a month during a monthly window. What we need, is a macro code that scans the "DataCount" tab and sends an email whenever the number of transmissions is less than two and the monthly window is closing. Example: Patient ID (Column A) Monthly Window (Column Y and Column AB) Events (Column Z) would need to have a number greater than two, five days prior to the weekly window closing.
9 freelancers are bidding on average $35 for this job
Hello I am a Doctor by profession but have bio Statician in my team. We both can provide you with the best possible outcomes. Discuss more details in chat Regards Dr Abbas Hamdani
Hi there, I can help you with your project . I am excel vba expert and have 10 years of experience in creating automations, database, query., macros , etc. Please message me to discuss more. Regards, ravinder
Hi, I am expert in advance excel. With skills like VLOOKUP, INDEX, MATCH, PIVOT tables and tricky formulas. I will complete the task in time and properly. Thanks