Linking sheets
 

I need to link a master sheet and a slave sheet. How do you copy and link the
2 sheets together so one sheet is identical to the other. The sheets are in
the same work book.
--
Rick

Perhaps something along these lines ..

Assume a sheet named: Master

In the slave sheet

Put in A1:

=OFFSET(Master!$A$1,ROWS($A$1:A1)-1,COLUMNS($A$1:A1)-1)

Fill across and down to cover the max expected working range that the sheet:
Master is likely to have, inclusive of any possible future insertions of
rows and columns within the initial / existing working range in Master (The
formula will cater for any future insertions of rows or columns *within* the
covered range after set-up)

For a cleaner look, you could suppress extraneous zeros
from showing in the slave sheet via:
Tools Options View tab Uncheck Zero values OK

Note: Though you could of course, try filling the *entire* sheet (256 cols x
65536 rows), it's NOT advisable, to keep calc speed and file size within
reasonable bounds.

Copying Formats
-------------
Copy the initial working range in Master

Right-click on A1 in the slave sheet paste special formats in the slave
sheet.

As any formats/formatting done in future insertions of new rows / cols,
and/or in existing rows/cols in Master after the initial copy format above
is executed within the covered range will *not* carry over automatically to
the slave sheet (unlike the cell values), you'll have to repeat the copy
formats as and when this happens to ensure identicality.

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Rick P" wrote in message
...
I need to link a master sheet and a slave sheet. How do you copy and link
the
2 sheets together so one sheet is identical to the other. The sheets are
in
the same work book.
--
Rick