I have 4 workbooks which have 5 sheets in each. All the worksheets are
the same layout apart from they are named mon-fri. Im trying to set it
up so when I amend one box it will amend and update all the other
sheets in the workbooks. When I was given the workbook to re design I
noticed that this was avail on some boxes using a file named
control.xls.

Can anyone help me cos I aint got a clue what this control file is and
its a pain keep amending every every worksheet in the books when I sure
there must be a way to update all in one go.

Many Thanks


--
shrek

Shrek,

Try this and you'll see the answer.

Take a new workbook.

Select Sheet1.

Hold down the Shift key, and select Sheet3.

Sheets 1, 2 and 3 should now be highlighted as selected.

Select cell A1.

Type something into it. Hello World will do just fine.

Examine cell A1 in all three Sheets. They should all say Hello
World.

If necessary now ungroup the sheets. Right click on one of the
sheets. Select Ungroup Sheets.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=488357