Skip to main content
2 of 2
added 4 characters in body; edited tags; edited title
user0
  • 27.1k
  • 10
  • 53
  • 78

Equivalent of IMPORTRANGE with script in Google Sheets

Since the Importrange() is not working as expected, do you know how I could express e.g the following function with a script?

={IMPORTRANGE("SheetKey","SheetName1!A:J") ; 
  IMPORTRANGE("SheetKey","SheetName2!A2:J") ; 
  IMPORTRANGE("SheetKey","SheetName3!A2:J")}