Google Script to Export Range to Another Spreadsheet [Duplicate]

Google Script to Export Range to Another Spreadsheet [Duplicate]

Is it possible to export a range of cells to another spreadsheet using a script? After the source range has been exported the source range will be cleared and manually repopulated.

Upon running of the script again the same range will be exported but added to the first export not overwrite the first export.

This would happen often, eventually compiling a large list of exported items.

Thoughts?

0

1 Answer

Take a look at Copy a complete list on one spreadsheet to append on the bottom of another spreadsheet, there's a script there that should get you started.

1
Marcus Vance
Author

Marcus Vance

Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.