Copy & Paste VBA Help (Fixing the result of a formula after a certain date)

[Dodge99X]

So I'm trying to create a spreadsheet for my summer budget as I am college student that isn't making a lot of money over the summer. I seem to have everything correct except two rows. These two rows rely on an input that I plan to update. Rows 10 and 11 deal with how much I am paying myself for personal spending. They are working on a set amount that I pay myself. But if I have excess money from the cells return with the proper amount to deduce from my account to return my current money on hand to the set value.

My problem is that the set value changes all of the data in those two rows. I want the cells that are in the column dated prior to the next column to keep the value as they were at the last time before the next column.

Ex.

A1 is July 10th and B1 is July 17th
C1 is how much money I want to have each week so lets say $20
D1 is how much I actually have so lets say $17
A2 =IF(D1>=$C$1,0,-ABS($C$1-D1))
A3 =IF(TODAY()>=A1,$D$1,D1-A2)
B2 =IF(A3>=$C$1,0,-ABS($C$1-A3))
B3 =IF(TODAY()>=B1,$D$1,A3-B2)

I want A2 and A3 to remain at the values they were last once the present date is B1. To my understanding there is no formula for this. Instead I need to use VBA. However, after hours of searching how to do this, I have been unable to deduce how to do this in VBA. I would attach a copy of my spreadsheet but I dont think I can.

Can anyone help me out?

 

[Dodge99X]

Due to research I learned that I need to copy and paste the cells at the desired date. can i do this using VBA?