VBA code copy specific range of cells even when additional rows are added

[topswim]

what I'm trying to do is copy a specific range of cells O29:O38 to O18:O27 automatically using VBA. I then Insert another 10 rows before O29 and enter new data in O29:O38 again and repeat the process: The information will also be retained from O29:O38 below the inserted cells. If there is a formula I can use that will always refence O29:O38 after inserting my rows that would help also, but so far, I lose the reference to those cells after I insert my rows even if formulas are set up in O18:O27 as $O$29, $O$30, etc. After inserting rows in this example it now displays in O18 as =$O8$38.

FYI- I will be performing other functions on cells O18:O27 prior to inserting my rows

 

[offthelip]

If all you have got below o29 : 38 is data why not just move the data with VBA instead of inserting new lines then all your equations will stay the same.

 

[topswim]

If all you have got below o29 : 38 is data why not just move the data with VBA instead of inserting new lines then all your equations will stay the same.

Trying to see how that may work