How do I set up a workbook so changing Sheet1 changes all sheets?
 

I have a worksheet as a master and I want to add sheets that contain only
some of the master information. But if I make changes to the master I want it
to change on the sheets. I've tried copying and pasting the link but the
formating doesn't copy, which is the most important part of this particular
spread sheet.

How do I get my formatting to copy over while still be able to have the
changes go to all sheets?

Try this:

1. Edit Move or Copy Sheets
2. Make sure the box "Create a Copy" is checked.
3. Select where you want to copy it
4. Press OK

It should create an exact copy of the sheet which you can then edit to
remove any unwanted information. After that you will need to make the
necessary links between MASTER and copy sheets. Please, get back to me
if you need more help.

Note:
Always experiment in a backup copy before doing it in your actual
data.

Regards
Juan Carlos


--
cscorp
------------------------------------------------------------------------
cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015
View this thread: http://www.excelforum.com/showthread...hreadid=376830