Linking incremental cells from another worksheet

A

Aaron Daniels

I am trying to link every fith cell in a column to sequential lines on my
main worksheet. The formula I am using for the first cell link is =+'Master
Query'!$F2 and I want the next cell to have the formula =+'Master Query'!$F7,
the next =+'Master Query'!$F12, etc... for 500 lines. Anyone have ideas on
how I can do this will minimal manual typing.
 
D

Dave O

Assuming your formulas are located in F2, F7, and F12: highlight and
copy F2:F12. Paste this into F17, which will provide formulas for F22
and F27. Highlight and copy F2:F27 and paste into F32. Highlight and
copy F2:F57 and paste into F62 and so forth. It's tedious but will
only take a few minutes since the range is doubling each time.
 
B

Bernie Deitrick

Aaron,

Enter this into the first cell, but hange the 3 to the row number of that
cell

=OFFSET('Master Query'!$F$2,(ROW()-ROW($A$3))*5,0)

Then copy down as far as you want.

HTH,
Bernie
MS Excel MVP
 
Top