Transferring numbers to new worksheet automatically [Solved/Closed]

Report
-
 tresi -
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 reply

Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
214
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.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!