=OFFSET($A$1,10*ROW()-10,0) entered in B1 and copied down.


Gord Dibben MS Excel MVP


On Wed, 5 Sep 2007 16:42:02 -0700, Duncan
wrote:

I want to copy a formula down a column but the cell reference needs to be
changing by more than one. ie. my formula in A1 is =B1, my formula in A2 is =
B11. So when I now copy the formula in Column A down I want my formula in A3
to = B21 but when I highlight A1 and A2 then drag down my formula in A3 is
=B3. Any help much appreciated.