Home / how to link sheets so one reflects changes to the other How to link sheets so one reflects changes to the other 31/03/2021 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 otherFormulaQUERY(Sheet1!A:D, "SELECT *")SORT(Sheet1!A:D)ARRAYFORMULA(Sheet1!A:D)ExplainedThe 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.ExampleI"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 FlashcardsThis 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 savedDraft 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 Linked194How 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.