Updating cell references

[shav]

HI all,
I a have a range of cells that have reference to other cells
Eg. a1 b1 c1
a2 b2 c2

Is there a quick way to change the refernces to the following
a8 b8 c8
a9 b9 c9

ie, increasing the row value in the reference by 7. Cheers
Sha

 

[Jim May]

In A1:C2 enter:
=INDIRECT("F"&$D1) =INDIRECT("G"&$D1)
=INDIRECT("H"&$D1)
=INDIRECT("F"&$D1+1) =INDIRECT("g"&$D1+1) =INDIRECT("H"&$D1+1)

In D1 enter either value of 1 or 9

Fill F1:H2 and F9:H10
with desired values to be brought back to the A1:C2

HTH