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, I think it works, but I have to do it manually each time. What I mean is the ability to automatically execute this function at a specific date. Do you think is it possible? @eddyparkinson can you give an example? Thanks a lot :) – tigerjack89 Jan 17 '14 at 9:35
-
Just create a method, put the code and create a periodic trigger on some day. Thats all :) – Hari Das Jan 17 '14 at 10:17
-
Thanks a lot Hari. But, as I can see, you can only select a range, not a specific hour. How can I solve? – tigerjack89 Jan 17 '14 at 14:53
-
I am talking about trigger in script editor not about range in spreadsheet. In script editor there is an option to create trigger on a given date. – Hari Das Jan 17 '14 at 15:08
-
Sure, what I mean is that in the trigger options you can only select a range. i.e. I can't set "Every Monday at 08:15 a.m.", but just "Every Monday from 08:00 to 09:00 a.m." – tigerjack89 Jan 17 '14 at 16:08
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.