naming references in workbooks in Excel X

[Elijah80]

Having difficulty in applying Book-Level and Sheet-Level Names in
Workbooks.
When I define a name in the Define Name dialog box and I then select
the name in the Name Box, it will select the reference on the worksheet
that I have used to define the name.
If I then move to another worksheet in the same workbook with identical
layout, the name I have defined appears in the Name Box, but when I
select it, it returns to select the reference in the Worksheet where I
made the original definition.
This does not always happen but I cannot find a sure way of defining
names in one worksheet that will always work in other worksheets with
similar layoute.
Any suggestions please.

 

[JE McGimpsey]

I cannot find a sure way of defining names in one worksheet that will
always work in other worksheets with similar layoute.

Names that you type in the name box are by default workbook-level names.
To create sheet-level names, use the sheet reference, e.g.:

Sheet1!MyName

This can only be done if you haven't defined MyName as a workbook-level
name.