Im new on google sripts and trying to improve. I was given a task to copy scripts from old spreadheet to new spreadsheet. It is possible ? Thank you. P.s. I looked up for this question in google but didn't found reliable answer.
0
votes
1 Answers
1
votes
Sure.
- Open one of the sample spreadsheets
- Copy it to your drive
- Open that copy
- Menu: Tools -> Script Editor
- Copy and paste contents into desired spreadsheet
Caution: If copied script makes reference to the old spreadsheet using a specific spreadsheet ID (via SpreadsheetApp.openById() for example) you'll need to tailor your code accordingly. Likewise for explicitly named sheets, folders and data. Presumably, you're reading up on the help docs? https://developers.google.com/apps-script/guides/sheets Good luck!
