Transfer of totals from one sheet to the next

  I have none 18:33 05 Sep 03

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


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


Oooops - of course.

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

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…