Thanks Max. I did this but it returned a reference error in each field. My
knowledge doesn't really go this far so perhaps I did something wrong.
--
Cheers
Nicole
"Max" wrote:
> Here's a slightly different interp on your post ..
>
> Assume you're linking a source range in Sheet1 to an equivalent range in
> Sheet2. And you want the "linked" range in Sheet2 to always "cover" the
> source range in Sheet1 in tandem, despite subsequent row / column insertions
> or deletions which may be made within the source range in Sheet1
>
> Source table in Sheet1 is presumed to start with the top left corner cell in
> A1 (in A1:C10, say)
>
> In Sheet2
> ---
> Put in A1:
>
> =OFFSET(INDIRECT("Sheet1!A1"),ROWS($A$1:A1)-1,COLUMNS($A$1:A1)-1)
>
> Copy A1 across and fill down
> to cover the max expected data range in Sheet1
>
> For example: Fill A1 to cover A1:E100, if you expect that the source range
> in Sheet1's A1:C10 may expand over time to this extent
>
> And for a cleaner look in Sheet2,
> suppress the display of extraneous zeros in Sheet2 via:
> Click Tools > Options > View tab > Uncheck "Zero values" > OK
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "Nicole" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > This is probably a question that has already been asked, but is it
> possible
> > to link one worksheet to another so that when rows are inserted into the
> > original sheet, they are automatically inserted in the linked sheet?
> > --
> > Cheers
> > Nicole
>
>
>
Bookmarks