How do I copy formulas down a sheet using increments?
 

I would like to be able to copy a formula down a column in increments of 7.
For example in cell A19 of sheet 2 the formula is: =+'sheet1'!A10. In cell
A20 of sheet 2 I would like it to be: =+'sheet1'!A17 and in cell A21 of sheet
2 I would like it to be: =+'sheet1'!A24 etc. etc. I don't want to have to
do it all manually if I can avoid it!

Thanks.

How do I copy formulas down a sheet using increments?
 

In Sheet2 A19 enter the below formula and drag it down

=INDIRECT("Sheet1!A" & 10+((ROW()-19)*7))

--
If this post helps click Yes
---------------
Jacob Skaria


"Linda" wrote:

I would like to be able to copy a formula down a column in increments of 7.
For example in cell A19 of sheet 2 the formula is: =+'sheet1'!A10. In cell
A20 of sheet 2 I would like it to be: =+'sheet1'!A17 and in cell A21 of sheet
2 I would like it to be: =+'sheet1'!A24 etc. etc. I don't want to have to
do it all manually if I can avoid it!

Thanks.