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 one page and want to have that data (the sum) as a snapshot on another page.
Thank you for your help.
- Figured it out!
Here is the formula I needed:
=SUM('Sheet name'!A1)
Thank you for your help!
10 Replies
- 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.- 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.- Go to the sheet where you want the reflected value to be, select the Cell where you need it, press = and then go to the original sheet and click in the cell that you want reflected and press enter.
