Excel calculations ?

  Hedontownee 06:29 13 Apr 05
Locked

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.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

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

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…