Hello,

I have for example an Excel file which contains sheets jan, fev, mar, april,
etc
In each sheet, I have cells from 1 to 30 (31) days.
I would like to select the cells from 1 to 30 and to give a name (label)
€œPLANNING€�.
For that I use the function Insert/ Name / Add on the sheet January. However
the label does not refer that only one sheet (January)..
If I select the sheet February and that I make the same operation, that will
modify the label €œPLANNING€� and now it refers only to the sheet FEBRUARY. How
to make to define a label PLANNING which refers to the sheet in progress and
with the same name of label €œPLANNING€�. Thank you for your assistance

Hi

Use Sheet specific names
Name =Jan!Planning
Refers to =Jan!$A$1:$A$31

Name =Feb!Planning
Refer to =Feb!$A$1:$A$28

--
Regards

Roger Govier


"noelalain" wrote in message
...


Hello,

I have for example an Excel file which contains sheets jan, fev, mar,
april,
etc
In each sheet, I have cells from 1 to 30 (31) days.
I would like to select the cells from 1 to 30 and to give a name
(label)
"PLANNING".
For that I use the function Insert/ Name / Add on the sheet January.
However
the label does not refer that only one sheet (January)..
If I select the sheet February and that I make the same operation,
that will
modify the label "PLANNING" and now it refers only to the sheet
FEBRUARY. How
to make to define a label PLANNING which refers to the sheet in
progress and
with the same name of label "PLANNING". Thank you for your assistance