richard oldcorn
Board Regular
- Joined
- Nov 12, 2002
- Messages
- 169
I am putting together several single sheets into one work book.
Each sheet is a small financial calculator.
Several of the sheets use the name "inflation" e.g. in one sheet called "gearing", another sheet called " level of cover".
How can I have different definitions for "inflation", so that, for instance i have, say, "inflation = gearing $b$15 for the gearing work sheet, and, say,
"inflation = level of cover$c12$ for the level of cover work sheet, and so on.
Currently when I change the formula to define "inflation" in one sheet, it changes on the other sheets.
Thanks.
Each sheet is a small financial calculator.
Several of the sheets use the name "inflation" e.g. in one sheet called "gearing", another sheet called " level of cover".
How can I have different definitions for "inflation", so that, for instance i have, say, "inflation = gearing $b$15 for the gearing work sheet, and, say,
"inflation = level of cover$c12$ for the level of cover work sheet, and so on.
Currently when I change the formula to define "inflation" in one sheet, it changes on the other sheets.
Thanks.