Member Avatar for momtworugrats

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?

  • 2 Contributors
  • 2 Replies
  • 108 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by momtworugrats
Member Avatar for timothybard

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.

commented: helped a lot +1
Member Avatar for momtworugrats

thanks so much! i got it to work.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.