dynamic linking

S

Stefi

Hi All,

I'd like to make a link pointing to a source cell in another workbook
containing a SUM function. My problem is that the reference of this source
cell changes when new rows are inserted in the source sheet.

How can this problem be resolved?

Thanks,
Stefi
 
G

Gary''s Student

In Sheet1 A1 enter:

=Sheet2!A3

This form will track inserted rows. So if two rows are inserted at the top
of Sheet2,
the formula will become =Sheet2!A5
 
Top