software

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