I have a workbook that we use as a tracker. All the tabs (except the 1st one) is a month. What I need is a code to loop through each monthly sheet & if E3:"last row" is blank then generate an email with the TO: person would be the value in column B of that row. Once the email is sent then it would put in the cell in column E, "Coached on "Date" & Time that the email was sent. Any help would be greatly appreciated & I have attached a copy of my workbook so you can have a visual to assist. Thank you very much!
Bookmarks