Macro in Google sheets put data in empty cell every month

by Dijkgraaf   Last Updated July 19, 2018 22:03 PM

My question pick up date and write in the following empty line? I want to copy a data from a fixed cell to a database and that it always comes under the last line.

For example,Data from cel A1 from sheet1 and write on sheet2 in D1 and then a month later the data from A1 from sheet1 write on sheet2 in D2 ectect. The data from D1 moust not change when we put de data in D2

I have a script but it does not work at all

/** @OnlyCurrentDoc */

function myFunction() { var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('D1').activate(); spreadsheet.getCurrentCell().setFormula('=Blad1!U29'); spreadsheet.getActiveRangeList().setNumberFormat('0'); };


Tags : google-sheets

Related Questions

Copying values between google sheets

Updated July 26, 2018 21:03 PM

Aggregate results by week and month for charts

Updated January 18, 2019 09:03 AM