I was hoping to find a script that does the following:
- Takes data from a particular spreadsheet,
- Duplicates that data to a new sheet as values only
- in the second spreadsheet it creates a new sheet based on the month
A bit more information I am producing monthly reporting which has custom scripts and configures working in the background - however this data is "live" in that it will change based on the current month.
Therefore I either need to print that data to a file per month i.e., each tab gets a month Jan, Feb, March etc or each tab can be set up in the receiving file to pull the data as a snapshot on a particular day via a trigger.
Basically an ImportData snapshot of a target sheet in another Spreadsheet file.