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.
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.