Linking incremental cells from another worksheet
 

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.

Linking incremental cells from another worksheet
 

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.

Linking incremental cells from another worksheet
 

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


"Aaron Daniels" wrote in message
...
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.