How do I copy formulas down a sheet using increments?

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.
 
J

Jacob Skaria

In Sheet2 A19 enter the below formula and drag it down

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import Comments 3
Copying Formula Issue 3
Copy sheet 2
Fill formula down for cells 74 rows apart 3
Copy reference cell with alternate column 4
How do you repeat a function in a formula 4
Copy Sheet #'s, but leave cell reference 3
Copying Cells From Multiple Worksheets to Create Summary Sheet 1

Top