Linking between Google sheets

[Packer16]

Does anyone know the syntax for linking cell between Google sheets? TIA.

 

Packer

[Sullivcd]

This worked for what I needed:

 

https://www.annielytics.com/blog/google-docs/how-to-import-one-spreadsheet-into-another-in-google-drive-video/

[SlowAppreciation]

Between files, or just between sheets of the same workbook?

[Packer16]

Between files in different workbooks.

 

Packer

[writser]

IMPORTRANGE is the command you need: https://support.google.com/docs/answer/3093340?hl=en

 

IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")

[SlowAppreciation]

IMPORTRANGE is the command you need: https://support.google.com/docs/answer/3093340?hl=en

 

IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")

 

Yeah I think this is what you need

[Packer16]

Thanks guys that worked great.

 

Packer