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.

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

VFX Oscar nominees 2017: Discover how the visual effects were created

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…