Transfer of totals from one sheet to the next

  I have none 18:33 05 Sep 2003
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 2003

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 2003

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 2003

Yes, good point except Copy, not Cut.

  xania 16:44 06 Sep 2003

VoG

Oooops - of course.

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?