Forum Discussion
How do I populate information from one worksheet to another?
- Figured it out!
Here is the formula I needed:
=SUM('Sheet name'!A1)
Thank you for your help!
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