1

I have two sheets, and a table that I want to be displayed on both sheets. I can use

=('Sheet_name'!A1)

to create a one-way dependency. However, is it possible to create a table that updates both ways? Changes in either sheet should appear in both sheets.

0

That is just not possible. Google Sheets can't handle such paradox, eg. to reference the reference of reference with itself.

  • Ok, is there a way to achieve the same end result using Excel, or some other method? – Oscar Brogden Apr 8 at 17:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.