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 cell 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 must 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');
};