using names

[richard oldcorn]

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.

 

[Mudface]

Define the names as local to the worksheet rather than at workbook level, ie use Sheetname!Name rather than just Name.