Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change sheet name in formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Need formula for sheet & cell reference | Excel Worksheet Functions |