Google Spreadsheet 2
Required skills: Support
I would like assistance in developing a Google Spreadsheet that on 1 worksheet lists names and credits for each individual and on another worksheet only lists the individuals from the first worksheet (in alphabetical order) that has 3 or more credits. There should be a way to update sheet 2 as changes are made to sheet 1.
Sheet 1 will be all manual. We will manually input the total # of credits for each person.
Sheet 2, will need to pull the names from sheet 1 but only the names and the account # (which will be in a column beside the name on sheet 1) of those that we have entered 3 or more credits for. As sheet 1 changes, sheet 2 should update automatically or there should be an easy way to run a script or something in the Google Doc to update Sheet 2.
This tutorial may help, http://www.google.com/google-d-s/scripts/writing_spreadsheet_data.html
Please bid if you are available as soon as possible and can complete this today. Thanks.
Sheet 1 will be all manual. We will manually input the total # of credits for each person.
Sheet 2, will need to pull the names from sheet 1 but only the names and the account # (which will be in a column beside the name on sheet 1) of those that we have entered 3 or more credits for. As sheet 1 changes, sheet 2 should update automatically or there should be an easy way to run a script or something in the Google Doc to update Sheet 2.
This tutorial may help, http://www.google.com/google-d-s/scripts/writing_spreadsheet_data.html
Please bid if you are available as soon as possible and can complete this today. Thanks.
Posted In:Support |
Related projects:
Alternative Google Spreadsheet Ui Using Php
a or delete etc), click on Save button and data will be saved to the spreadsheet
5, A page to allow navigation of all data in the table. Default is 100 row per page, and there should be Next and Prev link (like Google search result). The next and Prev link should also be used for search result.
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information, phs.phd at googlemail dot com
5, A page to allow navigation of all data in the table. Default is 100 row per page, and there should be Next and Prev link (like Google search result). The next and Prev link should also be used for search result.
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information, phs.phd at googlemail dot com
Google spreadsheet script functions (2)
tp://pagead2.googlesyndication.com/pagead/show_ads.js">
