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

Autonumber field in Excel that behaves the same as Access 0
Need Help with a VBA subroutine 0
Copy addition formula of non-consecutive horizontal cells 2
Section and Page numbering 0
How to make repeating drop-down lists? 2
Found few bugs in my daily routine of work in excel for MAC 0
Formula fill series? 1
Match Copy/Paste Macro almost there 0

Top