dynamic linking
 

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

dynamic linking
 

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
--
Gary's Student


"Stefi" wrote:

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

dynamic linking
 

Thanks Gary, fine!
Stefi


€žGary''s Student€� ezt Ã*rta:

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
--
Gary's Student


"Stefi" wrote:

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