I am making a spreadsheet for work. I have multiple worksheets in this particular file. How do I make it so I can just update one spreadsheet and it automatically updates another one?

8 Years
Discussion Span
Last Post by momtworugrats

Here are the steps to making one cell display the information in another cell. When the source cell is changed, the cell that refers to it will change as well:

1) Click on the cell that will refer to another cell
2) Type the equals sign in the formula bar.
3) Click on the source cell
4) Hit Enter

The cell that refers to the source cell will have one of the following formulas, depending on whether the two cells are on the same spreadsheet or different spreadsheets:
Same sheet example: =A1 (this would refer to the cell in column A and row 1)
Different sheet example: =Sheet2!A1 (this would refer to a cell in column A and row 1 of Sheet2.

Please let me know if you need any help.

Votes + Comments
helped a lot
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.