Reference a single formula across multiple sheets

[Rob1st]

Tried searching for this, but can't quite find what I need.

I have a workbook with lots of pages, every page is structured exactly the same, but the information within it varies.

I have a template sheet set up, so that if I want to change the labels on the sheet, I just change them on the template sheet, and they all change, easy.

The formulas within each sheet are also identical, so can I do this:

1, Place the formula on the template
2, Call the formula on each sheet from the template

Example:

Every sheet has a =SUM(A10:A220) formula in cell A1

Can I have this formula in Template!A1 as text and then somehow call that cell in A1 of every sheet, to work in every sheet?

I tried =INDIRECT(Template!A1) No Luck, but I am assuming there must be a way.

Why do I want this?

Well if I have a reference sheet where I can amend formulas once and it applies, instead of correcting formulas on every sheet, then it will save me lots & lots of time.

If the answer is in VBA I am also happy to consider, just have not found anything through searching.

Appreciate the help.

 

[Rob1st]

This is exactly what I want, but I can't get it to work, even with the simple example you gave.

Let me break it down:

The formula in A1 is TEXT? =B1/7
The Formula in C1 is GENERAL = Formula1

When I click on the C1 cell, it highlights A1, so it is looking at it, but all I get is #NAME

According to the Evaluate Formula system the issue is with FORMULATEXT

I have Excel 2010! That's the issue, looking for UDF to fix now.

Thoughts?

 

[Rob1st]

Worked Perfectly! Now I just need to change the formula in one sheet!

You're a genius thank you.

For all others working on Excel 2010 that want to do this, all you need do is add a module with this is it:

Function FormulaText(MyCell As Range)
FormulaText = MyCell.Formula
End Function

And the answer above will work!