Sorry - I've gone braindead trying to resolve this - so forgive me if I dont express myself very well ..
I have a formula that repeats every 10 cells, that I want to copy into the next 1000 cells, but I dont want the cell reference to increase by 10 each time I copy the block, I want it to increase by 1 - Not Clear ? let me demonstrate :-

cell a1 contains the formula ' =(Sheet3!$a1) '
cell a2 contains the formula ' =(Sheet3!$b1) '
cell a3 contains the formula ' =(Sheet3!$c1) ' and so on down to
cell a10 contains the formula ' =(Sheet3!$j1)

I want to copy these 10 cells and paste into the next 1000+ cells,
What I get is
cell a11 contains the formula ' =(Sheet3!$a11) '
cell a12 contains the formula ' =(Sheet3!$b11) ' and so on.

What I want is
cell a11 contains the formula ' =(Sheet3!$a2) '
cell a12 contains the formula ' =(Sheet3!$b2) ' and so on down to
cell a20 contains the formula ' =(Sheet3!$j2) ' and then

cell a21 contains the formula ' =(Sheet3!$a3) '
cell a22 contains the formula ' =(Sheet3!$b3) ' and so on down to
cell a30 contains the formula ' =(Sheet3!$j3) ' and so on until I get to about cell a1000

How do I do That ?
Its probably easy - but Ive gone simple trying to figure it out.