Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Linking

Posted by Gary on February 14, 2002 10:53 AM

How can you link one worksheet to another without having to link each individual cell and have the exact same format as the source page (font, color, shading, $$, %, blank cells instead of 0, etc.).

Re: Linking

Posted by Shaun on February 14, 2002 11:23 AM

Without knowing why you want to link two sheets together to have them be the same here is one simple way: You can right click on the sheet tab and select move or copy, create a copy, in current book. If you group the two tabs together by holding down the Ctrl key and clicking on the second sheet, then everything you type in the first one appears/changes in the second sheet. Hope this helps.
Shaun

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.