Edits to linked worksheets

[Guest]

Is there a simple way to add rows to several source worksheets and quickly update the destination worksheet with these new links?

 

[Dave Peterson]

If your formulas that do the link are nice, maybe you can just copy them down
the column(s).

That's the only way I know.

 

[Max]

Perhaps you're looking for something along this lines ?

Assume your source sheet is Sheet2
and your destination sheet is Sheet1

In Sheet1
----------
Put in A1:
=OFFSET(INDIRECT("Sheet2!$A$1"),ROW()-1,COLUMN()-1)

Copy across as many columns as required,
then copy down as many rows as required

For a cleaner look,
suppress zeros from showing in this sheet via:
Tools > Options > View tab > Uncheck "Zero values" > OK

The above is equivalent to the simple link formula in A1
: =Sheet2!A1, copied across, then down

but with the *difference* that if you insert
new *in-between* rows and/or columns in the source Sheet2
subsequently, the destination Sheet1 will auto-update
to capture the new insertions
(which the link formula won't)

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----

Is there a simple way to add rows to several source

worksheets and quickly update the destination worksheet
with these new links?