Same range, same name, different worksheet

[Gilbert De Ceulaer]

How can I - in one operation - give the same name to the same range in
different worksheets ?
("xyzlabels" refer to the same (label)-range, but as well in sheet "1999",
as in "2000", as in....)

 

[JE McGimpsey]

One way:

Choose Insert/Name/Define:

Name in workbook: xyzlabels
Refers to: !$A$1:$A$10

 

[Gilbert De Ceulaer]

Sorry, but this gives me "xyzlabels" but only in the first of selected
worksheets.
I would like "xyzlabels" to be created in 10 or more worksheets.

 

[Peo Sjoblom]

Works fine for me


--


Regards,


Peo Sjoblom

 

[Gilbert De Ceulaer]

I must be doing something wrong.
When I select 2001 through 2016,
Select A7:R7,
go to Inset,Define,Name,
type in Name in Workbook : vinlabels
refers to : !$A$7:$R$7
I have that range in 2001,
but when I look for it in 2007, it brings me back to 2001
What am I doing wrong ?

 

[Sasa Stankovic]

isn't name unique in workbook???? if you name one range xyz on first sheet
you are not able to name another range with xyz????

 

[Wondering]

Works fine for me too. Did you put the "!" in the reference - eg.
!$A$1:$A$10 ? . If you didn't the name will refer to the range A1:A10 only
on the sheet where you created it.

 

[Wondering]

You can use the same names on different sheets. You can have a name that is
both workbook level and sheet level. For example, MyCellA1 could be workbook
level to refer to cell A1 on sheet1 and also be defined at sheet level to
refer to cell A1 on sheet5. If you refer to MyCellA1 anywhere but sheet5
you'll get the contents of cell A1 on sheet1. On sheet5 if you refer to
MyCellA1, you'll get the contents of cell A1 on sheet5. Depending on where
you refer to the name, you may have to qualify it with the workbook name or
sheetname. You might want to do some research in the help file or in a good
book on Excel.

 

[Gilbert De Ceulaer]

No, I did it, but it doesn't work,
Now I am creating the '2002'!LABELSVIN = '2002'!!$A$1:$A$10 one by one, and
that works, but I know (somebody thought be before) it is possible

 

[Gilbert De Ceulaer]

O yes, I did

isn't name unique in workbook???? if you name one range xyz on first sheet
you are not able to name another range with xyz????

 

[Wondering]

I have no idea what you're doing wrong. On sheet1, I define the name
MyRange and in the refers to box I type =!$A$1:$A$10 and when I use the name
MyRange on sheet1 refers to A1:A10 on sheet1. When I use the name MyRange on
sheet2, it refers to A1:A10 on sheet2. And the same for the other sheets.