Transfer of totals from one sheet to the next

  I have none 18:33 05 Sep 03
Locked

I have tried to work out a formula so that totals will transfer from sheet one to sheet two. How do I do it?

  VoG II 18:45 05 Sep 03

Say your total is in Sheet1, A20

On Sheet2 enter the formula

=Sheet1!A20

If your sheet nhame contains spaces, enclose the sheet name in single quotes

='My Sheet'!A20

  xania 21:22 05 Sep 03

There is a useful alternative in Excel - Paste special. On the original cut the the cell i nquestion, then go to the new sheet/workbook and, using the <Edit> drop down menu, select Paste special then select <Paste link>. You iwll now find thayt, as the contents of the field in your original varies, so will the contents of your new.

  VoG II 21:25 05 Sep 03

Yes, good point except Copy, not Cut.

  xania 16:44 06 Sep 03

VoG

Oooops - of course.

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

Best Mac antivirus 2017