This tutorial demonstrates how to mirror cells by linking in Excel and Google Sheets.
Mirror Cells by Linking
When you work with multiple sheets in an Excel file, you can mirror cells by linking them across sheets. Say that you want to link value from cell B2, Sheet1 to cell B2, Sheet2. To do this, follow the next steps.
1. Enter a value in the source sheet (B1, Sheet1 – in this example, 10).
2. (1) Go to the target sheet (Sheet2), (2) enter = in cell B2, and (3) go back to the source sheet (Sheet1).
3. Click on the original cell in the source sheet (B2), and press Enter.
As a result, cell B2 on Sheet2 is now linked with cell B2 on Sheet1. If you click on B2, Sheet2, the value there is =Sheet1!B2. This means that every time you change the value of B2 in Sheet1, it will automatically change the value of B2 on Sheet2.
Now, change the value of cell B2 on Sheet1 from 10 to 15.
If you go back to Sheet2, you can see that value of B2 here is also updated to 15.
Mirror Cells in Google Sheets
You can use exactly the same steps to mirror cells in Google Sheets.