To add a label name on several sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To add a name of label on several sheets. 5
Update cell value based on name and specific date 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
Referencing a named range on another sheet 4
Referecing Worksheet names that are dates in a formula 2
Creating sheet references 4
Auto Change Formulas - Please Help. 2
Sheet name/number 4

Back
Top