Linked Questions

28
votes
1answer
168k 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 ...
-1
votes
1answer
5k views

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

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) ...
1
vote
1answer
30 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
0answers
12 views

SUM values across different Google Spreadsheets [duplicate]

Is there a way to sum values across different workbooks in Google Sheets? NB - Not different worksheets but different workbooks.
19
votes
9answers
79k 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
36k 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?
2
votes
3answers
16k 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 ...
6
votes
1answer
5k 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 ...
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 ?
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/...
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: =...
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
915 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
114 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 "...

15 30 50 per page