Continuing sum formula

[bamacwby]

If I have a number, say 1245 in A1, that is the number I want to start with and in B2 is the same number but I add a series of other numbers to B2 with the total in F4. With everyday I erase the series of numbers that were added to B2 but want to keep the total form F4 to be the new number in B2. I hope this makes sense. Thank you

 

[bamacwby]

Obviously, you are referring to a bunch of cells that are not shown in your screen print, as it only shows up to row 23.
In order to help, I think I would need to get a copy of your workbook, so I can see all the rows, and all the formulas, and try it the steps you are mentioning.
Are you able to upload your workbook to a file sharing site and provide a link to it here

Here you you

Dropbox

www.dropbox.com

 

[Joe4]

So, it sounds to me like you just want to copy the hard-coded value from C78 to I6. Is that right?

If so, you could copy the value from C78 to cell I6, while at the same time you could use the macro to clear out all the other cells you want cleared, i.e.

Sub MyReset()

    'Copy value from C78 and paste in cell I6
    Range("I6").Value = Range("C78").Value
    
    'Clear out entries cells to start over
    Range("M18:M21").ClearContents
    
End Sub

You can clear out other cells too, by adding similar lines to the "ClearContents" one above.

 

[bamacwby]

So, it sounds to me like you just want to copy the hard-coded value from C78 to I6. Is that right?

If so, you could copy the value from C78 to cell I6, while at the same time you could use the macro to clear out all the other cells you want cleared, i.e.

Sub MyReset()

    'Copy value from C78 and paste in cell I6
    Range("I6").Value = Range("C78").Value
   
    'Clear out entries cells to start over
    Range("M18:M21").ClearContents
   
End Sub

You can clear out other cells too, by adding similar lines to the "ClearContents" one above.

Where do I copy those codes to?

 

[Joe4]

Have a look here at this document which shows you how to store and run VBA code: How to Insert and Run VBA Code in Excel? - GeeksforGeeks
Note that there are many other tutorials and videos on this that you can find with a simple Google search on "excel how to create and run vba".