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
FYI- I will be performing other functions on cells O18:O27 prior to inserting my rows