Specific example of a redirection

[Robert Peirce]

'DATA'!B3 = "33"

'DATA'!B7 = "=INDEX(LINEST('ANNUAL DATA'!C3:C33,'ANNUAL DATA'!B3:B33),2)"
Several additional cells have almost exactly the same formula, just
referencing different columns.

I want to pickup the end of the columns, C and B and the others, by
referencing the contents of 'DATA'!B3. At this time, that row is 33.
Next year it will be 34, and so on.

I figured out how to use the INDIRECT() function in fairly simple
situations, but this one is eluding me.

 

[Bob Greenblatt]

'DATA'!B3 = "33"

'DATA'!B7 = "=INDEX(LINEST('ANNUAL DATA'!C3:C33,'ANNUAL DATA'!B3:B33),2)"
Several additional cells have almost exactly the same formula, just
referencing different columns.

I want to pickup the end of the columns, C and B and the others, by
referencing the contents of 'DATA'!B3. At this time, that row is 33.
Next year it will be 34, and so on.

I figured out how to use the INDIRECT() function in fairly simple
situations, but this one is eluding me.

The formula in B7 should read:
=index(linest(indirect("'annual data'!c3:c"&data!b3),........

Hope this helps.