Updating formulas in Excel - best solution

[MasterOfDestr]

This should move all formulas by a fixed amount (addrows) to cells further down and change the formulas to cells addrows further down.

Is that what you want to do?

I don't want use " fixed amount (addrows)" as range/base for the formulas will be different each month.

What about the data? Do you need to move it?

Not sure which "data" do you mean.

What about the old formulas? Do you need to delete them?

There are no old formulas. Only formula can be in the first row. Next the formulas needs to be filled down


Thanks for the code. Will try to adjust it (remove fixed amount) and test it.