??? is there a way (function?) to store a number gained by calucalations into another cell where it is stored as a number free of calculations

I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. 

Here’s it specifically (though I run into this in other areas)

1. The running total (run ttl) is made from ‘today’s total (gathered from some other calculations) added to the prior running total (prior ttl).
2. Right now I have to type the ‘prior total’ in …tomorrows ‘prior total’ is today’s ‘running total’
3. Is there a way to store the new running total in such a way that it automatically becomes the new ‘prior ttl’ for the next day?
4. If there were a way to automatically store it in a cell some where it just stored as a number (free of calculations) that would do…is there such a function? Or method?

It words: is there a ‘function’ or ‘way’  to store numbers derived from calculations that are rewritten so the are 'free of the calculation that wrote them’....(do they have such a function) and

…..I have some other questions....

Thanks

CAladdin

If you only close the workbook once a day, you could just move running over to prior. Or even ask if that should be done.

 CAladdin,

There are two options.  The first is to redesign your spreadsheet as a daily tracker.  This usually involves creating a row for every day, where your Running Total would reference your previous day's 'Today' and 'Prior ttl' to create your new 'Prior ttl'.  Here's an example.

With this sort of model you'e need to decide how you wanted to split up your 'Pairs'.  You could use multiple tables on a worksheet, or you could simply create a worksheet for each pair.  The advantage to this is the daily tracking capability.

Alternatively if you want to maintain your above format, you will need to consider a code solution.  I'm not sure that wouldn't be almost as much work as manually transferring data.  I would do it, but then I'd rather write code than manually transfer data any day of the week. I've spent an hour to automate a manual task that takes 5 minutes once every month.  A year just to break even on the time.

I hope that at least gives you an idea as to direction.

David B.

 Thank you for your time, insight and ideas...