Hi
I have a workbook with 2 sheets. In sheet 1 cell A1 I have a formula
that reads =sheet2!B1.
In sheet1 cell A2 I have a formula that reads =sheet2!B75.

I would like to be able to fill the formula down in sheet1 so that it
references each cell 75 rows apart from column B in sheet2

Does anybody know how to do this easily, I have to copy the formula
from sheet1 down 500 rows

Thanks in advance
Reg