Hello all, I have what is hopefully a simple solution to solve.
I have a sheet for staff to complete entries into columns A-G a single row at a time.
In column H I have a check to make sure all entries are made and return a 1 if anything is missing.
In column I u have the users email address.
I am looking for a macro that when run will send an email to the address in column I, to tell the user one or more entry is missing and to provide the referee column A.
Also, I want it so that is a single user has 2 or more invalid entries, then these are included on the same email rather than individuals mails.
Any help would be much appreciated.
I have a sheet for staff to complete entries into columns A-G a single row at a time.
In column H I have a check to make sure all entries are made and return a 1 if anything is missing.
In column I u have the users email address.
I am looking for a macro that when run will send an email to the address in column I, to tell the user one or more entry is missing and to provide the referee column A.
Also, I want it so that is a single user has 2 or more invalid entries, then these are included on the same email rather than individuals mails.
Any help would be much appreciated.
