Transferring numbers to new worksheet automatically

Tresi - Feb 26, 2015 at 04:38 AM
 tresi - Feb 28, 2015 at 05:09 AM
Hello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer the weekly total (as a number, not a formula) to the next week as carried forward but when I copy and paste, the numbers don't appear, just #REF. I used to study A level ICT and I'm sure I vaguely remember a simple way to do this, but can't figure it out. Help!

1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Feb 26, 2015 at 06:53 PM
Hello Tresi,

Could you up load a sample of your work book (be careful with any sensitive data) so that we can have a look at what you are wanting to do.

You can use a file sharing site such as DropBox or GE.TT.

thanks for the offer - I've managed to resolve this with the help of a friend.