I have a worksheet which copies a group of cells below the last data line in row A by using a macro and a button. When the button is hit the range A30:DQ54 is copied and pasted below the last row of data in row A. This works well.
The problem is I need the formulas in columns I to P (I30:P54)to reference the Yellow Row even when inserting rows in the section just copied. This can be seen in the range A80:DQ104 on the attached sheet, in this range I am able to make the formula with absolute numbers so when inserting rows the formulas still reference the yellow row (Row 80). The problem formulas are only in the columns I-P.
My question: is there a way to write the formula in cells I30:P54 so that when they are copied with the button, the formulas will always reference the yellow line even when inserting new rows between the top row (yellow) and the bottom row (green) of the range? (After copying)
I've attached the page so you can see the problem better.
Bookmarks