Thanks David, thats what I'm after

"David Biddulph" wrote in message
...
"John" wrote in message
...
Thanks Ronlim

Not quite, my Sheet2 formula cells are continuous, whereas the source on
Sheet1 are not continuous, thus

Sheet1A1 will be referenced to a formula in Sheet2A1
Sheet1A10 will be referenced to a formula in Sheet2A2
Sheet1A19 will be referenced to a formula in Sheet2A3

etc

I just want to copy my Formula in Sheet2A1 down (easily)

Yes, OFFSET sounds like a good solution.
=OFFSET(Sheet1!A$1,9*(ROW()-1),0)
--
David Biddulph