dynamic linking

[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

[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
--
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
>

[Stefi]

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
> >