On 03/09/2014 13:14, RussellMc wrote:
> 2. What I want is
>
> In Sheet 1 I want the name eg "MyIncome" to refer to cell B27 in Sheet1
> In Sheet 2 I want the name eg "MyIncome" to refer to cell B27 in Sheet2
> In Sheet 3 I want the name eg "MyIncome" to refer to cell B27 in Sheet3
> ....
> In Sheet N I want the name eg "MyIncome" to refer to cell B27 in SheetN
You want the scope of name local to sheets:
http://exceluser.com/excel_help/questions/localnames.htm

>
> 3. I did discover another feature I was unaware of
>
>
> If I have
>
> A          B
> FRED   123
> BILL    466
> JOE     789
>
> Then if IN COLUMN  B I enter the formula  "=3DBILL"
> it will return 466
> Without my having defined the names
This is a kind of feature that I dont like!


--=20
http://www.piclist.com/techref/piclist PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.