Well, I think you need to have a clearer idea of what it is you want to do.
If you had formulae then all that messing about with deleting and inserting
rows and columns may screw them up anyway. It might be that a macro solution
would be best - make the changes then click on a button to rebuild the
sheets.

But, you need to be able to say what it is that you want to achieve.

Pete

"J James" wrote in message
...
I unfortunately don't have formulas in the additional worksheets. Also,
where would I place a formula, what cell do I put it in? For example, I'm
inserting rows, deleting rows, changing some of the information in the
columns and I'm having to update each worksheet as well as the pivot
tables
that are associated with these worksheets.
--
J James


"Pete_UK" wrote:

If you have Automatic calculation set (usually the default) and you have
formulae in those other worksheets which depend on values in the master
sheet, then they will be updated automatically if you change a value in
the
master sheet.

In those subsidiary sheets, you might have a formula like this:

=master!A1 * 20%

which will give you 20% of whatever is in cell A1 of the master sheet.

The syntax for these linked formulae is:

'sheet name'!cell_reference

Apostrophes are required if your sheet names have spaces in them.

Hope this helps.

Pete


"J James" wrote in message
...
I have a workbook that contains multiple worksheets, one of the sheets
is
the
master sheet and I would like to know if anyone knows how you can set
it
up
so that when you make changes in the master sheet, the other worksheets
will
automatically be updated? Haven't been able to figure it out. Any
help
would be much appreciated.
--
J James