Excel calculations ?

  Hedontownee 06:29 13 Apr 2005

Hello again Folks
I've been trying to figure out have to do the following calc in excel ????
Within a workbook there are severael sheets
I have column of figures totalled on one sheet and I want to copy that total to a summary on another sheet within the same workbook.
I want to make that total on the summary page able to update the summary total as it the total accrues on the main sheet holding the original list and total?????? Phew!!!
If you can understand that little lot I'd appreciate some advise please

  Monoux 06:52 13 Apr 2005

Have you tried to use COPY on the total on the individual sheet then selct the cell you want that total to apear on on the Summry sheet right click then select paste special then click Link cells. this should make the cell on the summary update every time the total on the individual sheet alters

  Hedontownee 08:56 13 Apr 2005

Well done that man.
I hadnt noticed the "link" in the special paste windows. Easy when you know how:-)
Thanks very much

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

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone