2

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.

1
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
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.