Excel 2007 Formula troubles

[lmh]

I use a workbook with a Master worksheet and 12 worksheets broken out by
month. I would like to be able to make a change in the master worksheet and
have the same change occur in the other worksheets. There is no adding
multiplying, etc just a simple change in one cell to be followed by changing
the other worksheets. Is this possible? Thanks

 

[Gavin]

I use a workbook with a Master worksheet and 12 worksheets broken out by
month.  I would like to be able to make a change in the master worksheet and
have the same change occur in the other worksheets.  There is no adding
multiplying, etc just a simple change in one cell to be followed by changing
the other worksheets.  Is this possible? Thanks

What change are you trying to make? Formula change (are all of the
sheets linked?)? Or a Formatting change?

 

[lmh]

Thanks for your suggestion.Yes will work if you want to change the same cell
in every sheet. I have to change the dollar amount on Master worksheet cell
E3. I need that changeto follow through on the other worksheets but in
different locations on those other worksheets. Example: master sheet cell E3
must match sheet1!C3,sheet2!D3,sheet3!F3,sheet4!H3

 

[Pete_UK]

You could link those cells back to E3 on the Master sheet with this
formula:

=Master!$E$3

Just copy into the appropriate cells of each sheet.

Alternatively, you could apply a name to Master!E3 (eg Fred), and then
in those other cells you just need to put:

=Fred

Hope this helps.

Pete

 

[lmh]

I have to change the dollar amount on Master worksheet cell
E3. I need that change to follow through on the other worksheets but in
different locations on the other worksheets. Example: master sheet cell E3
must match sheet1!C3,sheet2!D3,sheet3!F3,sheet4!H3
Thanks

 

[lmh]

I like your suggestion about applying names. That seems to work the best.
Thanks!

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

I like your suggestion about applying names.  That seems to work the best.
Thanks!






- Show quoted text -