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 into "File B"?

From what I've seen, the built in function IMPORTRANGE only works to reference information from a different sheet within the same file and does not work for inter-file communication... unless there is some cool voodoo stuff that can be done.



Imports a range of cells from a specified spreadsheet.

The above means that if you add it correctly to a cell in File B it could import data from File A.

It's worth to say that in this site there are 180 questions and answers about and IMPORTRANGE at this time.

| improve this answer | |

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