Changing the Master Sheet Formula
 

Hallo

I have a Master sheet with a few formulas and a few other sheet they are all
the same as the master sheet. So what i need if i change a formula in the
master sheet it needs to change it in the other sheets to is that possible i
know cell values are easy.

Regards
Markus

Perhaps instead of using the same formula, you could link to the Master
sheet

=Master!E1

then when you change the formula in E1, the other sheet will pick up those
changes.

--
HTH

Bob Phillips

"Markus" wrote in message
...
Hallo

I have a Master sheet with a few formulas and a few other sheet they are
all
the same as the master sheet. So what i need if i change a formula in the
master sheet it needs to change it in the other sheets to is that possible
i
know cell values are easy.

Regards
Markus

That does not take the Formule from Master it takes the value that was
calculated in the master sheet

"Bob Phillips" schrieb:

Perhaps instead of using the same formula, you could link to the Master
sheet

=Master!E1

then when you change the formula in E1, the other sheet will pick up those
changes.

--
HTH

Bob Phillips

"Markus" wrote in message
...
Hallo

I have a Master sheet with a few formulas and a few other sheet they are
all
the same as the master sheet. So what i need if i change a formula in the
master sheet it needs to change it in the other sheets to is that possible
i
know cell values are easy.

Regards
Markus

Maybe this UDF from David McRitchie:

http://mvps.org/dmcritchie/excel/formula.htm#usesameas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Markus wrote:

Hallo

I have a Master sheet with a few formulas and a few other sheet they are all
the same as the master sheet. So what i need if i change a formula in the
master sheet it needs to change it in the other sheets to is that possible i
know cell values are easy.

Regards
Markus

--

Dave Peterson

That is correct, but surely the effect is the same.

--
HTH

Bob Phillips

"Markus" wrote in message
...
That does not take the Formule from Master it takes the value that was
calculated in the master sheet

"Bob Phillips" schrieb:

Perhaps instead of using the same formula, you could link to the Master
sheet

=Master!E1

then when you change the formula in E1, the other sheet will pick up
those
changes.

--
HTH

Bob Phillips

"Markus" wrote in message
...
Hallo

I have a Master sheet with a few formulas and a few other sheet they
are
all
the same as the master sheet. So what i need if i change a formula in
the
master sheet it needs to change it in the other sheets to is that
possible
i
know cell values are easy.

Regards
Markus