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

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?