Hi there,

I have a row of formulas that I want to update with new row references that
are a set # of rows away from the orginal.

ie) Row 1: =A1+B1, =C1+D1, =F1+G1, =H1+L1

I need Row 1 to look like this, adding 5 rows onto each first cell reference:

ie) Row 1: =F1+B1, =H1+D1, =K1+G1, =M1+L1

Is there an easy way to do this besides going into each cell indidually to
make the change? I have a lot of sheets and a lot of columns that need to be
changed.

Thanks!