How to transfer added figures from one worksheet to another without losing the total?

0 votes
asked Oct 4 in General Discussions by Sherry (290 points)

Hello, everyone, I am Sam and use Excel regularly, so, I want to know while working on multiple worksheets how do I transfer added figures from one worksheet to another without losing the total. 

1 Answer

0 votes
answered Oct 4 by Tammy (310 points)

Well, you can transfer the added figures from one worksheet to another in two ways.

Here follow the steps to do so:

First one:

Copy the cell from the original sheet, then go to the new sheet, but do not paste. Do Edit>Paste Special>Values. This will copy the value instead of the formula to the new sheet.

In a second way:

Set up a formula on the new sheet that points to the total on the back sheet. If your total is on Sheet2, cell D20 you would enter this formula on sheet 1:  =Sheet2!D20

And then, as you change data on Sheet 2 and the totals change, they will automatically update on Sheet 1.

Try anyone, that is easier for you.

Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.
...