Excel calculations ?

  Hedontownee 06:29 13 Apr 05

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 05

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 05

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…