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.
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.
- I have done that - and the value does not match.
- When I go to the sheet I want the value pulled from (sheet 1), it seems like it is pulling that cell from the current sheet I am on (sheet 2).
I put the = on sheet 2 where I want it reflected. I go to sheet1 and click the cell that I want to show. Go back to sheet 2 and press enter. The value is zero. When I click the cell again to look at the formula - it looks like it is pulling that same cell location on current sheet, sheet2