CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Diarox Carbon
Diarox Carbon

Reputation: 25

Google Apps Script: copy ranges to new range use connect formula

i want to connect ranges sheetA to SheetB.

sheet A ==================================
         A      B      C      D      E      F    
1                             x      x      x
2

sheet B ==================================
         A             B                C 
1  =sheetA!(A1)  =sheetA!(B1)  =sheetA!(C1)
2

i already used copyto, only con copy original link.

sheetA.getrange(1,3,1,3).copyto(sheetB.getrange(1,1,1,3))

Upvotes: 0

Views: 69

Answers (1)

TheMaster
TheMaster

Reputation: 50462

  • Set sheetB!A1 to =sheetA!A1
  • Then, use autofill to fill up rest of the range

Sample script:

var sheet = SpreadsheetApp.getSheetByName("sheetB");
var sourceRange = sheet.getRange("A1");
sourceRange.setValue("=sheetA!A1")
var destination = sheet.getRange("A1:C20");
sourceRange.autoFill(destination, SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);

Upvotes: 1

Related Questions