VBA Saving Data

[Dannybert]

I have a table to keep track of amounts and prizes. I want to use a VBA code to be able to make a button that can save the data from this week and start a new week in the row below.

This is what the table looks like now:

So after running the macro, I would like to get it to start a new row and change some stuff on the current (lowest) row. It would look like this:

So after running the macro (VBA code), it should start a new row and display the currentDate (which should stay the same after pasting it). Then it should copy the data from the first row like I displayed with the asterixes.
After completing the date for the new row, it should change the 'End Amount' and 'End Value' to only be left with the number/currency instead of the formula, because the formula is to display real-time changes. So it should be fixed after starting a new row.

The last 4 columns can be copied over directly since those calculations and formulas are relative.

Thanks already!

 

[johnnyL]

Who the heck stole my period?

oops. Yeah it works with the period.

 

[Logit]

Ok ! Happy you have an answer. Cheers !

 

[johnnyL]

Hey thanks for helping me out, but this code is giving me an error on 'wsMasterRange'. So it doesn't run now and I tried to change it to 'wsMaster.Range' but that didn't help

@Dannybert what error did you get after inserting the period?

 

[Dannybert]

@Dannybert what error did you get after inserting the period?

I’m not sure it still gave me an error for some reason. Maybe it just went wrong when I tried it. If it worked on your side it’s me I think haha. Thanks again!