Send to a Friend

2davidc8's avatar

Is it possible to link cells on 2 different spreasheets?

Asked by 2davidc8 (10189points) July 6th, 2017

I know that you can have a cell on one spreadsheet refer to another cell on the same spreadsheet such that if you change the value of the first, the value of the second cell is automagically updated.

I’d like to know if you can do this across spreadsheets. It’s OK if both spreadsheets need to be in the same “Book” (to use Microsoft’s term).

Can someone please show me?

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.