How can I update all workbooks in one go

S

shrek

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

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

Many Thank
 
R

rsenn

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.
 
Top