Færdiggjort

comparing cell values in different sheets of the same spreadsheet

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]

Evner: Google App Engine, Javascript

Se mere: how to compare two excel files 2010, spreadsheet compare, excel find matching values in two worksheets, excel compare two worksheets, how to compare two excel sheets for differences in values, how to compare two columns in different excel sheets using vlookup, how to compare two excel sheets using vlookup, compare two excel sheets and highlight differences, need people, need people create ptc accounts, need people email addresses links 2009, need people sign dating website, need people good photoshop, need people know php mssql, sum values multiple sheets excel 2007, need people promote product, visual basic sum values several sheets, need people call leads, excel combine data different sheets, need people work

Om arbejdsgiveren:
( 1 bedømmelse ) Toronto, Canada

Projekt ID: #17697711

Tildelt til:

swroot

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 Flere

$41 CAD på 1 dag
(1 bedømmelse)
0.7

6 freelancere byder i gennemsnit $45 på dette job

kishu0079

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 Flere

$30 CAD på 1 dag
(4 bedømmelser)
2.7
umairmalik10

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 Flere

$111 CAD in 3 dage
(5 bedømmelser)
2.3
jinwonjiu

Hello, thank you for your project offer. I have read read your project description very carefully now have some points needs to be clear. I can say that I am a kind of Google API expert, and responsible for my work don Flere

$30 CAD på 1 dag
(1 bedømmelse)
0.4
moussa8121977

Dear sir , I am ready to help in your task , and finish it asap , ready to start working now if you are interested thanks and regards

$25 CAD på 1 dag
(0 bedømmelser)
0.3
$35 CAD in 2 dage
(0 bedømmelser)
0.0