Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change footer in workbook w/o changing on each wksht? | Excel Discussion (Misc queries) | |||
Problem making versions of a table by changing sourse data in another workbook | Excel Discussion (Misc queries) | |||
change a function in a workbook without changing every cell | Excel Worksheet Functions | |||
I entered 11/22/2004 in excel workbook and it keeps changing to ## | Excel Worksheet Functions | |||
Changing bulk Link references to different workbook. | Excel Discussion (Misc queries) |