Greetings,
I have a table in the range D14:N28. I wrote a macro that appends a new year of data at row 14, which increases the range of the table to D14:N29, and calculates the percent change for each column in row 31 (e.g. (D14-D29)/D29 ect.). The problem is that I need the formula to be dynamic, so that when the next year of data is appended to the table, the percent change is calculated in every column in row 32 and accounts for the new year of data in the formula (e.g. (D14-D30)/D30).
Thanks for the help in advance,
I have a table in the range D14:N28. I wrote a macro that appends a new year of data at row 14, which increases the range of the table to D14:N29, and calculates the percent change for each column in row 31 (e.g. (D14-D29)/D29 ect.). The problem is that I need the formula to be dynamic, so that when the next year of data is appended to the table, the percent change is calculated in every column in row 32 and accounts for the new year of data in the formula (e.g. (D14-D30)/D30).
Thanks for the help in advance,
