View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
noelalain
 
Posts: n/a
Default To add a label name on several sheets



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