Hi. I want to be able to have an excel workbook automatically add new years to all the relative tables and fill formulas for each column or row.
I have tried to record a macro and I manually auto-fill each table that would need a new row whenever it begins a new year, however whenever trying to run the macro it displays an error.

What I simply need is for the macro to take the last row(s) of data and copy down the formulas in each column.

Below is a sample table.
Sample Table.xlsx