We have a Google sheet that we want a set number of rows and columns to be referenced into another sheet. However, those rows and columns are in the middle of the original sheet, and we want additional entries to populate in the new sheet without any outside cells from the selected cells in the original to populate in the new sheet.


You are probably looking for IMPORTRANGE
From the ImportRange functions page

Imports a range of cells from a specified spreadsheet.
Sample Usage
IMPORTRANGE("abcd123abcd123", "sheet1!A1:C10")
IMPORTRANGE(spreadsheet_key, range_string)

spreadsheet_key - The long sequence of characters in the "key=" attribute of the URL. In the new Google Sheets, use the entire URL.

The value for spreadsheet_key must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text. range_string - A string, of the format "[sheet_name!]range" (e.g. "Sheet1!A2:B6" or "A2:B6") specifying the range to import.

The sheet_name component of range_string is optional; by default IMPORTRANGE will import from the given range of the first sheet.

The value for range_string must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

Notes A maximum of 50 IMPORTRANGE calls are supported on a single spreadsheet. This limit is removed in the new version of Google Sheets. In the new version of Google Sheets, spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE. The first time the destination sheet pulls data from a new source sheet, the user will be prompted to grant permission. Once access is granted, any editor on the destination spreadsheet can use IMPORTRANGE to pull from any part of the source spreadsheet. The access remains in effect until the user who granted access is removed from the source.

If you can't find the key, you can use the URL of the sheet you are referencing. If I misinterpreted your question, let me know.

  • 1
    It sounds to me like the OP is trying to import multiple ranges of cells at once so that it DOESN'T import a specific range, eg. import Rows 1-5 but NOT 3. I think IMPORTRANGE is on the right track, but a way to exclude a given range would need to be implemented into the function somehow. – SightSpirit Oct 9 '15 at 20:07
  • 1
    Spent a few hours trying to find a way to do this. Couldn't find one. Closest way is to make an array for each column or row. – Aethroz Oct 10 '15 at 18:57
  • 1
    Well, the OP never clarified anything so +1 for your effort. – user79865 Oct 17 '15 at 3:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.