CODEWITHSUNDEEP
google-apps-script
Bala
Bala

Reputation: 77

Google App Script: get values from range and set them to another range in different sheet

I did spend some time to find solution for this, but in vain.

I am a beginner to google appScript.

I have list of values in sheet1(ASINs to review) from (B5:B60) and its dynamic(number of rows change due to query on the sheet). I am trying to pro-grammatically pull them and try to paste them in sheet2(app).

I am able to successfully pull the data, but unable to paste them in sheet2.

My code:

    function myFunction() {

  var asinsToReview = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("ASINs to Review");
  var lr = asinsToReview.getLastRow();
  var title = asinsToReview.getRange(5, 2, lr).getValues();


  var pasteSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("app");
  var pasteRange = pasteSheet.getRange("A2:A").setValue(title);

}

Upvotes: 2

Views: 16818

Answers (1)

Cooper
Cooper

Reputation: 64032

Something like this should work:

 function myFunction() {

  var asinsToReview = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("ASINs to Review");
  var lr = asinsToReview.getLastRow();
  var title = asinsToReview.getRange(5, 2, lr).getValues();


  var pasteSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("app");
  var pasteRange = pasteSheet.getRange(2,1,lr,1).setValues(title);

}

Upvotes: 4

Related Questions