Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROTECTING/UNPROTECTING SHEETS | Excel Discussion (Misc queries) | |||
Linking two sheets in different books | Links and Linking in Excel | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |