I am brand new to attempting to write scripts for google sheets.
I am managing a list of camp counselors, their schedule, attendance, pay, and the overall budget of the camp.
I have 5 separate sheets, one for the counselor list, one for the schedule, one for the attendance, one for the pay, and one for the overall budget.
in each sheet, there is a list of the current counselors that references back to the master counselor list sheet.
I want to be able to easily add new counselors to the master list and have it update across the document.
at the bottom of the counselor list is a counselor named "anchor".
I want to know if its possible to add button to the menu toolbar that, when clicked, will search for "anchor" in the appropriate column, then insert a new row above the cell that has "anchor", and then type "New Counselor" in the cell above "anchor".
After it updates the master counselor list, I would like it to search the other 4 sheets for "anchor" in the appropriate columns, insert a row above "anchor" and then autofill the cell above "anchor".
Like I said I am very new to this, If anyone could point me in the right direction I would be very thankful.