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