Linking different cells from one sheet to another in same workbook
 

I've been trying to link certain cells from work sheet A, separated by 7 rows
and same column, to work sheet B. 'Summary Data'!$B$32 is an example of
the formula in sheet B but the next cell down would have to be ='Summary
Data'!$B$39, 7 cells down from the previous one.

how do I add rows to the first formula without having to modify each formula
for the next 500 cells down?
--
John

Linking different cells from one sheet to another in same workbook
 

On sheet B, I would enter, say, 32 in cell A1. Then, 39 in the next, and then
fill down the number of rows you need.

Then, in another column, enter

=INDIRECT("SheetA!$B$"&A1)

and copy down!

"John" wrote:

I've been trying to link certain cells from work sheet A, separated by 7 rows
and same column, to work sheet B. 'Summary Data'!$B$32 is an example of
the formula in sheet B but the next cell down would have to be ='Summary
Data'!$B$39, 7 cells down from the previous one.

how do I add rows to the first formula without having to modify each formula
for the next 500 cells down?
--
John

Linking different cells from one sheet to another in same workbook
 

=OFFSET('Summary Data'!$B$32,(ROWS(A$1:A1)-1)*7,) and copy down.
--
David Biddulph

"John" wrote in message
...
I've been trying to link certain cells from work sheet A, separated by 7
rows
and same column, to work sheet B. 'Summary Data'!$B$32 is an example of
the formula in sheet B but the next cell down would have to be ='Summary
Data'!$B$39, 7 cells down from the previous one.

how do I add rows to the first formula without having to modify each
formula
for the next 500 cells down?
--
John