Use Formula from another worksheet

[cjwagner]

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.

 

[Tom Hutchins]

Select all 14 sheets, then enter your formulas. The same entries will be made
on every selected sheet at once.

Hope this helps,

Hutch

 

[B. R.Ramachandran]

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]

Thanks for the response and spelling out how to select all the sheets. I
have since tried holding teh control key and selecting each, and the shift
key to select a series.

This opens up another question. Each spreadsheet will contain the
formula. which does what I need but can this be done another way. Just
for my knowledge. something like a ' =UseFormula( Sheet1!C5) ' ;-0

Was trying to think of how it could be done on the way home yesterday and
came up with that.