How do I copy formulas down a sheet using increments?

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

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.
 
In Sheet2 A19 enter the below formula and drag it down

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