comparing cell values in different sheets of the same spreadsheet

Hi, I can fulfil the task within 1-2 hours Need help with a simple Google Script. I have a Google Form that contacts need to fill out with their contact info. As they fill it out their email addresses are collected by default, which will be captured in column B of Sheet 1. Sheet 2 contains the list of email addresses who needs to fill out the form. The script needs to compare the responses against the master list. If someone's email address is missing from the responses list, an email reminder would be sent with details. Once the script is completed I would get an email letting me how many people have responded so far and how many more still need to. Link to the spreadsheet: [login to view URL]

Hello , I think I don't need to write about my self . I just want say that , This is so simple task that , I can complete this within 1 hour. I ensure you that, After seeing my work ,You will hire me for your all future projects. You will need to pay me after successfully completion of project and testing. Thanks Kishan

Hi, I've read project's description and seen the sheet you shared. I've few questions regarding this: Task is: - You will fill sheet 2 with email, first and last names. - Script will run and if any email present in sheet 2 is not in sheet 1, it will send reminder on that email. - Users will fill sheet 1. - When user fill sheet 1, how that user is removed from sheet 2? - At the end you will receive email about how many users filled the sheet. Right?