Linking

You can link a field in a Spreadsheet to another field in:

Linking is a way to tie information in one field to information contained in another. When you link fields, if you change the value in one field, the value in the other field automatically changes too.

Links can be either one-way or two-way:

One-way and two-way links can work between documents: a spreadsheet can have a one-way or two-way link to another spreadsheet or a Write document (see Linking through fields).

See:

One-way links in a spreadsheet

Two-way links in a spreadsheet