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