As the title, is there a way to have a "print" of the content of a sheet periodically? i.a., I'd like to have a trigger that every Monday at 08.15 A.M. copy the contents of a group of a cell of a sheets into another specific group of cell of another sheets.
var sheet1 = SpreadsheetApp.getActiveSheet.getSheetByName("mySheet1"); var sheet2 = SpreadsheetApp.getActiveSheet.getSheetByName("mySheet2"); sheet1.getrange("A1:C7").setvalues(sheet1.getrange("B1:D7").getvalues);
Where A1:C7 is the destination range and B1:D7 is the source range. I have not tested it but it should be like this.
Yes, google-apps-script will do that. It is easy if you know how to program.
This also might do what you need. Some spreadsheet formulas that can insert, update, transmit and add a user interface. www.cellmaster.com.au/Stack.html - It is something I have been working on, a few people are using it.