coding and scripting in google spreadsheet

Here is the link to the google sheet:-

Scripting will be done for this sheet only. Please keep in mind that everything will be online.

I'm trying to collect data from one sheet that are located in a different locations and post them in another sheet as a list.

In this file we I would like to collect information from this sheet "Client Profile" and post them to this one "Client Profile List View"

I would like to collect from "Client Profile" this information:

1. Full Name, found in cell "i2, i24, i46, i68, i90, and so on..."

2. Email Address, found in cell "AR2, AR24, AR46, AR68, AR90, and so on..."

3. Mobile, found in cell "BW2, BW24, BW46, BW68, BW90, and so on..."

4. ID Number, found in cell "i3, i25, i47, i69, i91, and so on..."

5. Nationality, found in cell "AC3, AC25, AC47, AC69, AC91, and so on..."

6. Gender, found in cell "AO3, AO25, AO47, AO69, AO91, and so on..."

7. Medical Condition, found in cell "BD3, BD25, BD47, BD69, BD91, and so on..."

8. Blood, found in cell "BK3, BK25, BK47, BK69, BK91, and so on..."

9. T-Shirt Size, found in cell "BU3, BU25, BU47, BU69, BU91, and so on..."

10. DOA, found in cell "CA3, CA25, CA47, CA69, CA91, and so on..."

And post them to this sheet "Client Profile List View" under the following order:

1. Full Name, to be posted under "B9"

2. Email Address, to be posted under "D9"

3. Mobile, to be posted under "C9"

4. ID Number, to be posted under "E9"

5. Nationality, to be posted under "F9"

6. Gender, to be posted under "G9"

7. Medical Condition, to be posted under "H9"

8. Blood, to be posted under "i9"

9. T-Shirt Size, to be posted under "J9"

10. DOA, to be posted under "K9"

Now the project will be divided in 2 missions

Mission 1:

1. At raw number 178 its the start of a new profile. So if a new client registered we will add another profile on raw 200 and repeat that for every new client.

2. Years will be added as well, now all profiles has 2017, we will need to add 2018 soon, and 2019 when its time and so on, so all raws will be moved down, nothing is fixed in place in this sheet.

3. We just need to take data from data from the first 2 raws of each profile.

Second mission:

1. Now in the "Client Profile" sheet, go to the second client "John Michle" on November you will find a "✔️" on that month for his membership on Sun-Tue-Thu. That mean that this client joined a 4 week program and he is attending 3 times a week

2. now go to "Class Capacity" shert and go to November at raw 55. Now that client joined a 4 week program and he is attending 3 times a week, we would like to create a formula or script whatever,, to make the "✔" that we put on "client profile" sheet to be posted here in "Class Capacity" sheet automatically

3. now if 2 clients joins on same day and date than : go to november 12 on "Cass capacity". as you can see each class has 21 slot. so if two or more clients booked at the same day, their ✔ will be added to the class capacity

Last requirement:

we will need a reporting system that show us each day who is attending as a list for example in november 12 we have 3 ✔, we need to see names of this 3 ✔ in another sheet. to know who booked in this day as a list view

Skills: Data Entry, Excel, Javascript, PHP, Web Scraping

See more: google spreadsheet script get cell value, google sheets script functions, google apps script for beginners, google sheets script examples, google spreadsheet script tutorial, google apps script tutorial pdf, google sheets script editor, google script examples, google spreadsheet scripting, import data wordpress google spreadsheet, sync excel google spreadsheet, perl scripting google results, google spreadsheet finance tse, mlsca google spreadsheet, manuale per google spreadsheet, commands google spreadsheet finance, google spreadsheet access table, use google spreadsheet access table, php form google spreadsheet, google finance google spreadsheet

About the Employer:
( 38 reviews ) Gurgaon, India

Project ID: #15637438

7 freelancers are bidding on average ₹357/hour for this job

₹277 INR / hour
(22 Reviews)
₹277 INR / hour
(15 Reviews)

A proposal has not yet been provided

₹1000 INR / hour
(14 Reviews)

Hello, Hope you doing well, I am a qualified and dedicated Web developer having 5+years of experience in Designing & Development, I have good expertise in modern Web development ,Rest API's and AWS Based Cloud Serv More

₹277 INR / hour
(7 Reviews)

In this task, I assure you that I will be providing quality output. I specialized in data entry and web based research. My previous experiences honed me to develop such skill set that makes me a well-rounded worker. Th More

₹277 INR / hour
(1 Review)

Hello I have got your job posting on Data Entry Project. According to your job description you need a fast worker for Data Entry. For your kind information I agree to do this job. I am fully expert in Data Entry, cop More

₹277 INR / hour
(0 Reviews)

A proposal has not yet been provided

₹111 INR / hour
(0 Reviews)