Hello,

Right click on the Sheet1 tab and click "Select All Sheets" (Now anything
you do on Sheet1 will be automatically done in all sheets)

You can now enter any formula in Sheet1 Cell A5 (e.g., =C6*B7) (It is ok
even if the formula returns an error on Sheet1)

To get out of "Select All Sheets" mode, click on any individual sheet tab.

Repeat the above procedure whenever you want to change the formula in A5.

Please click "Yes" if this post is helpful.

Regards,
B. R. Ramachandran




"cjwagner" wrote:

I have a workbook with 14 worksheets.


Sheet 1 Cell A5 C6*B7

Sheet 3 Cell C6 5
Sheet 3 Cell B7 9
Sheet 3 Cell D15 4


Sheet 3 Cell A5 = ?????

Want Sheet 3 Cell 5 to look at Sheet 1 Cell A5 get the formula (C6*B7) and
use the numbers from the cells C5 and B7 from Sheet 3 and end up with 45 in
Sheet3 Cell A5.

Also If I Change the formuls in Sheet 1 Cell A5 to C6*D15 it would
change Sheet3 Cell A5 to 20.

Rather than copying the new formula to each worksheet, One sheet would hold
the formulas to do the calcs. All the worksheets would be the same layout so
the called cells would be the same. Does that make sense to anyone. Can
it be done in Excel without programing (VB) or Macros?

Thanks.