View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lmh lmh is offline
external usenet poster
 
Posts: 9
Default Excel 2007 Formula troubles

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

"Jacob Skaria" wrote:

I am not sure whether this will work; since you havent mentioned what change
you are going to do...but try the below

Right click on the shee tabSelect all Keeping the selection do the change
in one of the sheets

If this post helps click Yes
---------------
Jacob Skaria


"lmh" wrote:

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