Import multiple ranges from one Google Sheet into another
19,003
Use formula:
={unique(importrange("link...","'Sheet1'!d5:o1000"));
unique(importrange("link...","'Sheet2'!d5:o1000"))}
The result is two imports one behind another, see more info here.
There's no better way to do this. Alternative is to combine formula as text and then convert string into furmula using script. See how in this question.
Author by
Marc L
Updated on June 15, 2022Comments
-
Marc L almost 2 years
I am trying to import multiple sheets in one Google Sheet into another Google workbook. I can get
ImportRange
to work for one sheet but how do I use it for multiple sheets, or alternatively, how do I combine multipleImportSheets
in one column?=unique( importrange("https://docs.google.com/spreadsheets/d/...", "'Kramerville KH'!d5:o1000"))
I want to be able to add another range to that, e.g.
'Emalahleni KH'!d5: o1000
.