I have make a macro in google sheets for transfer data from a cel to an other cel

function myscript(){
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    spreadsheet.setActiveSheet(spreadsheet.getSheetByName('blad1'), true);
  var cellValue = spreadsheet.getRange('A1').getValue();
var rowToUpdate = spreadsheet.getLastRow() + 1; //Gets the row after the last row on that sheet with data
  spreadsheet.getRange("B" + rowToUpdate).setValue(cellValue); //Sets the value to the next row to the value we grabbed earlier

The script is working but now i will add a extra order in de script. Please who can my help me whit the script.

I will the data from row A1:A10 transform to B1:K1 and when i do the next command than will i transform the data to a row +1

Your Answer

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

Browse other questions tagged or ask your own question.