-1

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.

pnuts
  • 17,883
  • 5
  • 55
  • 103
user133317
  • 1
  • 1
  • 2

1 Answers1

1

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 and IMPORTRANGE at this time.

Community
  • 1
Rubén - Volunteer Moderator -
  • 46,305
  • 18
  • 101
  • 297