I have 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 same edit must reflect on the other. How can I do that ?
You can use the following formula's in sheet2 (add them in
A1 of course).
QUERY(Sheet1!A:D, "SELECT *")
The last formula is the most straight forward, because nothing can be done in its current state. The other two allow you to do some tweaking, of which the first formula is the best equipped.
I've created an example file for you: range reference
Do you want to do this to every single cell in the 2nd sheet, or just for some of them?
If it's just for some of them, then put a formula in every single cell, saying to set it equal to the same cell in Sheet1,
eg in cell B3 in Sheet2, use the formula = 'Sheet1'!B3
(assuming that your sheets are called Sheet1 and sheet2).
You can put the same relative formula into each cell by just copying and pasting: by default, spreadsheet forumulas are relative, so they are smart enough to change the row and column references depending on where you paste them.
This means that if you copy that formula from Sheet2, cell B2, and past it into Sheet2, cell D4, then it will appear as ='Sheet1'!D4 without you having to do anything.