On the attached file, the first item I am asking the "AddaShift" Macro to perform is copy row 17 and insert it directly above. While it does some other things properly, the only thing which I cannot get it to do is automatically update the formula in Cell J17. I would like for it to continue all the way to the last row which contains data but it keeps losing 1 row each time the macro runs. I assumed the formula would keep going to the last row with data but unfortunately not. Anybody have any suggestions?

Attached Files

PEUG (Rolling 30-Shift Average).xls (419.0 KB, 11 views)