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!
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!