so I found a great answer to a question that I had about connecting two different spreadsheets with a link that would allow you to edit either one and the other would update, and I found this great thread with some code on it that seemed to be exactly what i was looking for however I am very new to coding in general and don't understand what I need to do to get the script to work properly

(I put in the targetId and the sheetName already but i dont know what to do with the rest of it).

Any and all help would be greatly appreciated.

Just as a little FYI the project that I am doing is meant to have only text and numbers and is meant to connect a specific sheet on one spreadsheet with a specific sheet with the same name on the other spreadsheet.

  • Welcome. It's not clear what you are asking. What do you know about coding? Do you know the basics of JavaScript like declaring functions, variables, data types,...? Have you already read developers.google.com/apps-script/guides/sheets? – Rubén Mar 9 at 4:26
  • Hi Ruben i have looked over the code and I now think i understand everything except what to replace range and value with in lines 6 and 7, that's all. thanks – Oliver Nicholls Mar 9 at 12:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.