Linked Questions

29 votes
1 answer

Reference data from another 'spreadsheet' in Google Docs/Drive [duplicate]

Is there a way i can reference data from another Google Spreadsheet in Google Docs/Drive? e.g., spreadsheet-A, sheet 1, column A is a dynamic reference of spreadsheet-B, sheet 1, column E I'm not ...
sam's user avatar
  • 6,833
-1 votes
1 answer

How to reference a cell in a different file [duplicate]

I have two separate Google Sheets files ("File A" and "File B") that are in two different places in my Google drive. Is it possible for me to reference a range of cells in "File A" to be copied ...
user133317's user avatar
0 votes
1 answer

Pulling column from sheet 2 and importing into another workbook [duplicate]

So I need to find the formula to pull a column out of one page of my Google Docs spreadsheet and insert it into a separate workbook. Here are some more details: all rows from column C (part number) ...
WinterWierdo's user avatar
1 vote
1 answer

Is there a way to pull or search for data from other sheets? [duplicate]

We use Google Sheets for tech commission sheets (track jobs and hours). Right now we have 2 years (2017&2018) in 1 set of sheets, 1 sheet for each month (jan 17, feb 17, etc). So instead of adding ...
Austin Anderson's user avatar
28 votes
13 answers

How can I get Google Sheets to auto-update a reference to another sheet?

I am using an external application to enter data into a Google Spreadsheet. This workbook is then referenced by a separate workbook (with the IMPORTRANGE(spreadsheet_key, range_string) function) that ...
tlewis3348's user avatar
15 votes
2 answers

Importing only certain rows between spreadsheet documents

Document 1 has many rows of data. How do I import into document 2 only those rows that have a certain value in column C?
user2338585's user avatar
5 votes
4 answers

How to SUM() a column from one Google Spreadsheets in another spreadsheet

Has anyone been able to return the SUM() result of a column in one Google Spreadsheets to a different spreadsheet? I am trying the ImportRange(key, criteria) but I am not having any success. I am ...
H. Ferrence's user avatar
8 votes
3 answers

Is it possible to link a cell in Google Spreadsheets to a Google text document? (not spreadsheets)

I learned here on Web Applications how to link a cell in Google Spreadsheet to a cell in another Google Spreadsheet: How do I link a cell in Google Spreadsheets to a cell in another document? Is ...
Pythonista's Apprentice's user avatar
1 vote
2 answers

Reflect changes in on sheet to another on Google spreadsheet

I have two sheets on a Google Spreadsheet. One of which is the copy of the other. Now what I want is, when I edit one sheet, the same edit must reflect on the other. How can I do that ?
Uvais Ibrahim's user avatar
0 votes
1 answer

Import Range on Google Spreadsheet

I want Cell D1 of this link: To be imported to E9 of this link:
Floyd Minglana's user avatar
1 vote
1 answer

How do I Import a Range from one Google Spreadsheet into another?

I am getting the same error as described here except not for the same reason. I am using the new Google Sheets, so I am supposed to be able to paste the entire source URL into the sheet, like so: =...
tlewis3348's user avatar
2 votes
1 answer

How to get data between tabs in Google Spreadsheets

is it possible to get a value from a tab cell and work with it in another tab? Tab 1 (T1) row working hours (A) who (B) 1 3 Mike ------------------------------- Tab 2 (T2) ...
vitto's user avatar
  • 161
1 vote
1 answer

CONTINUE function is annoying me? [closed]

I am trying to pull data from other Google spreadsheets into specific cells on my current sheet by using the IMPORTRANGE function. It's working well in some cells, but it others, it keeps getting the ...
Erika's user avatar
  • 19
0 votes
1 answer

Sum values across multiple Sheets IDs automatically by creating a formula?

I used this post to have all Google Sheets IDs in a folder Getting all files' file-id from a folder in Google Drive I would like to make a formula or script to sum values in table across all these ...
Hassan Almaateeq's user avatar
1 vote
1 answer

Lookup/Copy data from different sheets?

I am creating a schedule sheet in Google Spreadsheets that will have a number of different people inputting their own information. I would like the Director to be able to open a single document that "...
Rome's user avatar
  • 23

15 30 50 per page