May 26 2021 06:55 AM
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.
May 26 2021 07:05 AM
May 26 2021 07:40 AM
May 26 2021 08:04 AM
May 26 2021 08:05 AM
May 26 2021 08:19 AM - edited May 26 2021 08:21 AM
There is another way to do this. Use the "Named range" capability of Excel.
Give the sum in sheet1 (or sheet whatever) a name, for example "ExpTotal"
Then in Sheet 2 (or sheet whatever) all you need to do is enter =ExpTotal
As to how to give a name. You could do something like this. I've entered three numbers and then totaled them in cell C6. In cell B6 I've entered the text ExpTotal. Then go on the menu at the top of your screen and click on "Insert" then "Name" then "Create" and you should see a dialog box like the one shown below:
Click on the "OK" and your cell is named.
Now you can use it anywhere, in any formula or just by itself in your workbook--same sheet, different sheets--just by referring to that name.
For example, if you wanted to add a 7% tax you could enter =ExpTotal*1.07
May 26 2021 08:20 AM
May 26 2021 08:24 AM
May 26 2021 08:25 AM
May 26 2021 08:41 AM
SolutionMay 26 2021 08:43 AM
May 26 2021 08:41 AM
Solution