How to link sheets so one reflects changes to the other

I have actually two sheets on a Google Spreadsheet. One of which is the copy of the other. Now what I want is, when I edit one sheet, the very same modify need to reflect on the various other. How can I execute that ?


*

*

You have the right to use the following formula"s in sheet2 (include them in A1 of course).

You watching: How to link sheets so one reflects changes to the other

Formula

QUERY(Sheet1!A:D, "SELECT *")SORT(Sheet1!A:D)ARRAYFORMULA(Sheet1!A:D)

Explained

The last formula is the most right forward, because nopoint deserve to be done in its current state. The various other two enable you to carry out some tweaking, of which the initially formula is the ideal equipped.

Example

I"ve produced an instance file for you: selection reference


*

Do you desire to carry out this to eextremely single cell in the 2nd sheet, or simply for some of them?

If it"s just for some of them, then put a formula in eexceptionally single cell, saying to set it equal to the very same cell in Sheet1,

eg in cell B3 in Sheet2, usage the formula = "Sheet1"!B3

(assuming that your sheets are dubbed Sheet1 and sheet2).

You have the right to put the very same relative formula into each cell by simply copying and pasting: by default, spreadsheet forumulas are loved one, so they are smart enough to readjust the row and column recommendations relying on wright here you paste them.

See more: Midterm Quiz 4 Flashcards

This indicates that if you copy that formula from Sheet2, cell B2, and past it right into Sheet2, cell D4, then it will certainly appear as ="Sheet1"!D4 without you having to carry out anypoint.


Share
Improve this answer
Follow
edited Apr 15 "14 at 11:20
answered Apr 15 "14 at 10:16
*

MaryC.fromNZMaryC.fromNZ
7,09111 gold badge1515 silver badges2929 bronze badges
5
Add a comment |

Your Answer


Thanks for contributing a solution to Web Applications Stack Exchange!

Please be sure to answer the question. Provide details and share your research!

But avoid

Asking for assist, clarification, or responding to other answers.Making statements based upon opinion; ago them up via referrals or individual suffer.

To learn more, view our tips on composing great answers.

See more: Commissioner Forms Of Government Were At Their Height Of Popularity


Draft saved
Draft discarded

Sign up or log in


Sign up using Google
Sign up using Facebook
Sign up making use of Email and Password
Submit

Article as a guest


Name
Email Required, but never shown


Post as a guest


Name
Email

Required, but never before shown


Post Your Answer Discard

By clicking “Message Your Answer”, you agree to our terms of company, privacy plan and also cookie policy


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


The Overflow Blog
Featured on Meta
Linked
194
How carry out I connect a cell in Google Spreadsheets to a cell in an additional document?
4
“Circular dependency detected” error in Google Sheets
Related
5
Auto create and name new sheet in Google Spreadsheet
2
Copy one Google Spreadsheet to another
3
Google Spreadsheet SQL subquery “wright here not in”
2
How can I import the totality sheet to one more Google spreadsheet?
5
How can I cause a function once switching sheets within a spreadsheet?
13
How can I import a column from one sheet right into one more sheet of the exact same Google Sheets spreadsheet?
0
Can you make a sheet in Google Sheets visible for particular group?
1
Copy Sheet To New Spreadsheet
0
Function to copy fields from one sheet to another based upon IF statements
Hot Network Questions more warm inquiries

Inquiry feed
Subscribe to RSS
Inquiry feed To subscribe to this RSS feed, copy and paste this URL right into your RSS reader.


*

Web Applications
Company
Stack Exchange Network-related
website architecture / logo © 2021 Stack Exadjust Inc; user contributions licensed under cc by-sa. rev2021.4.1.38963


Web Applications Stack Exchange functions ideal with JavaScript permitted
*

Your privacy

By clicking “Accept all cookies”, you agree Stack Exadjust can keep cookies on your device and disclose indevelopment in accordance with our Cookie Policy.