Looking for someone who is familiar with scripting with Google Docs spreadsheets. Need a custom spread sheet modified to do the following:
1. Script to create a new “(C)” tabs in spreadsheets for items listed on “Key Data” sheet column A (if possible)
2. Method to copy any formulas or validation rules on “(C)” tabs when a new row is added at the bottom
3. Update the “Update Brothers/Talks” script
a. So that blank rows are omitted
b. Remove home phone, cell phone and email colums
c. Change talk numbers so that:
i. They are either in one cell, comma spereated, ascending or
ii. They are in their own cells in ascending order
1. Shrink the columns as small as possible
d. Insert the congregation name in column 2
e. Enable filtering on all (R) tabs
4. Fix minor errors with existing scripts
5. Merge functions witin existing scripts so that there is just a single "Update" button.
6. Create 1-2 tabs where data from previous year can be copied in, and allows similar reporting of "what has changed since the previous years"