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

0 votes
asked Oct 4, 2017 in General Discussions by Sherry (330 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, 2017 by Tammy (390 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.
...