-2

With Google Sheets how do I automatically import a cell value from one file to another?

Or can it only be done between sheets within the same file?

pnuts
  • 58,317
  • 11
  • 87
  • 139
Garrick
  • 1
  • 1

1 Answers1

0

If you search for reference another spreadsheet in google in Google and click on the second search result you get here

It explains there that you can import a range of values from another spreadsheet with IMPORTRANGE(spreadsheet_key, range_string). Where spreadsheet_key is the url or the id of the other spreadsheet and range_string is the range e.g. Sheet1!A1:B2.

Tesseract
  • 8,049
  • 2
  • 20
  • 37