Linked Questions

29
votes
1answer
176k views

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 ...
23
votes
11answers
96k views

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 ...
12
votes
2answers
40k views

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?
7
votes
2answers
7k views

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 ...
2
votes
4answers
24k views

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 ...
2
votes
1answer
1k views

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) ...
1
vote
1answer
3k views

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: =...
1
vote
1answer
120 views

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 "...
1
vote
1answer
64 views

Auto-Import Master Spreadsheet

I'm fairly new to Google Spreadsheets and completely useless when it comes to functions and formulas. Is there a way to take info from multiple sheets within a workbook and compile them into a ...
1
vote
2answers
5k views

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 ?
1
vote
1answer
999 views

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 ...
1
vote
1answer
56 views

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 ...
0
votes
1answer
2k views

Import Range on Google Spreadsheet

I want Cell D1 of this link: https://docs.google.com/spreadsheet/ccc?key=0AupKcedJ0nhPdFFyMVhySWNvNzlYTV9RZ1FmYXdKc0E&usp=sharing#gid=2 To be imported to E9 of this link: https://docs.google.com/...
0
votes
1answer
28 views

How to import cell data from one workbook to a different workbook?

All answers I have reviewed say use IMPORTRANGE by referencing the "KEY=" in the URL of the source cell. I find no "KEY=" in the source URL. So I always receive a "parse error."
0
votes
0answers
14 views

Compare two GSheets files and paste a cell value if selected values match

I would like to compare two different GSheet files (NOT sheets within the same file) and return a cell value if three (or more) values match. In File 1 ( https://docs.google.com/spreadsheets/d/...

15 30 50 per page