'IMPORTRANGE to import a range of multiple cells
I need to reference a sheet (called Working) that is full of price and stock info. I've created a new spreadsheet, and want to import values from the Working sheet without having to insert =importrange for every cell.
I'm using the following code:
=IMPORTRANGE("1aHJ8wTbmJ.......","Working!A39")
Is there a way to reference the Working sheet that is faster to achieve than doing it cell by cell?
Solution 1:[1]
As the name implies, IMPORTRANGE imports a range of cells from a specified spreadsheet..
As shown in the documentation, the second parameter in the function is a reference to a range of the spreadsheet, and so all you need is to provide a valid reference to a range within that sheet, e.g.:
=IMPORTRANGE("Sheet Url...", "Working!A:A")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | sinaraheneba |