Auto update worksheets

[J James]

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.

 

[Pete_UK]

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]

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.

 

[Pete_UK]

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]

I did say what I wanted to achieve and don't think that was an appropriate
response.

 

[Pete_UK]

No offence intended - perhaps someone else might be able to give you better
advice.

Pete

 

[Fred Smith]

Life just isn't fair, is it James. To get free, accurate advice, all you
have to do is ask a clear question. If that's not something you can handle,
then this group isn't for you.

Regards,
Fred.