Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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.
From IMPORTRANGE
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 google-spreadsheets and IMPORTRANGE at this time.
