Same range, same name, different worksheet
 

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....)

Same range, same name, different worksheet
 

One way:

Choose Insert/Name/Define:

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


In article ,
"Gilbert De Ceulaer" wrote:

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....)

Same range, same name, different worksheet
 

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.

"JE McGimpsey" wrote in message
...
One way:

Choose Insert/Name/Define:

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


In article ,
"Gilbert De Ceulaer" wrote:

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....)

Same range, same name, different worksheet
 

Works fine for me


--


Regards,


Peo Sjoblom




"Gilbert De Ceulaer" wrote in message
...
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.

"JE McGimpsey" wrote in message
...
One way:

Choose Insert/Name/Define:

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


In article ,
"Gilbert De Ceulaer" wrote:

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....)

Same range, same name, different worksheet
 

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 ?


"Peo Sjoblom" wrote in message
...
Works fine for me


--


Regards,


Peo Sjoblom




"Gilbert De Ceulaer" wrote in message
...
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.

"JE McGimpsey" wrote in message
...
One way:

Choose Insert/Name/Define:

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


In article ,
"Gilbert De Ceulaer" wrote:

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....)

Same range, same name, different worksheet
 

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????


"Gilbert De Ceulaer" wrote in message
...
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....)

Same range, same name, different worksheet
 

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.

"Gilbert De Ceulaer" wrote in message
...
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.

"JE McGimpsey" wrote in message
...
One way:

Choose Insert/Name/Define:

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


In article ,
"Gilbert De Ceulaer" wrote:

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....)

Same range, same name, different worksheet
 

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.

"Sasa Stankovic" wrote in message
...
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????


"Gilbert De Ceulaer" wrote in message
...
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....)

Same range, same name, different worksheet
 

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

"Wondering" wrote in message
t...
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.

"Gilbert De Ceulaer" wrote in message
...
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.

"JE McGimpsey" wrote in message
...
One way:

Choose Insert/Name/Define:

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


In article ,
"Gilbert De Ceulaer" wrote:

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....)

Same range, same name, different worksheet
 

O yes, I did

"Sasa Stankovic" wrote in message
...
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????


"Gilbert De Ceulaer" wrote in message
...
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....)

Same range, same name, different worksheet
 

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.


"Gilbert De Ceulaer" wrote in message
...
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

"Wondering" wrote in message
t...
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.

"Gilbert De Ceulaer" wrote in message
...
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.

"JE McGimpsey" wrote in message
...
One way:

Choose Insert/Name/Define:

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


In article ,
"Gilbert De Ceulaer" wrote:

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....)