Forum Discussion
Solved
How do I populate information from one worksheet to another?
Hello! I am using windows 10 Pro - Excel 2016. In my workbook - I am trying to have information generated on one page reflect/mirror on another page. Example: I am calculating information on ...
- Figured it out!
Here is the formula I needed:
=SUM('Sheet name'!A1)
Thank you for your help!
If I am understanding your question correctly, if you are wanting to reference cell A1 from Sheet1 then your Sheet2 A1 would be =Sheet1!A1
You could add more to the formula if you need to calculate something.
You could add more to the formula if you need to calculate something.
- How do you verify what the sheet is called? - I renamed each one.
But yes, the sum calculated sheet 1 - I want it to populate that sum on sheet 2. If I make adjustments to sheet 1 - I want it to automatically update on sheet 2.