I have set up a multiple sheet spreadsheet for monthly stats at work. Each sheet has a final monthly row of figures. What I want to do is copy this last row to the following month and add this to the last row of that months figures - so that I can have a row showing an accumlative total.
I have tried 'paste special' using 'Values' when I set the spreadsheet up, but the line stops the same as when I pasted it. What I mean is adding info to the previous sheet (of which this is a copy of the final total row - if you are still following me) nothing changes.
I suppose at the end of each month I could copy and paste the final row but what I really want is for it to calculate it automatically.
I am only self taught on excel,so if anyone can actually understand what I am trying to explain a very 'simple english' reply would very much be appreciated.