Sometimes you’ve got a couple Google Sheets that you would like to have speak to each other.

In my Farm Spreadsheets I use a master crop list with all the growing info for that crop - DTM, yield, spacing, and so forth. I then refer to that crop list from a bunch of other spreadsheets - especially my crop plan spreadsheets.

Different spreadsheet systems have different ways to connect those sheets.

In Google Sheets, you’ve got the IMPORTRANGE formula.

You enter that formula in the one cell, and then the formula imports all the data from the other sheet.

It’s important to realise that you cannot modify this imported data - it can only be modified in the original sheet. But if you modify the original data, it will also update the imported data.

That being said, you can reference that imported data with your whole arsenal of spreadsheet formulas - SUMIF, INDEX MATCH, FILTER, and more!

Go and get connected!

Get The Spreadsheet at
[ Ссылка ]

Send me your Farm Spreadsheet Questions
[ Ссылка ]

For more about The Farmer Spreadsheet Academy
[ Ссылка ]

свернуть