Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To add a name of label on several sheets.
I have for example 3 sheets January, February, Mars representing the days of the months. I would like to add a label "planning" by selecting days 1 to 31. How to make so that the name of the label planning is the same one for January, February, March. Thank you for your assistance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To add a name of label on several sheets.
Hi!
If these sheets are kept in a sequential order: Summary | Jan | Feb | Mar | Apr |.....................| Dec | Then in the InsertNameDefine refers to box: =Jan:Dec!$A$1:$A$31 Biff "noelalain" wrote in message ... I have for example 3 sheets January, February, Mars representing the days of the months. I would like to add a label "planning" by selecting days 1 to 31. How to make so that the name of the label planning is the same one for January, February, March. Thank you for your assistance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To add a name of label on several sheets.
It looks good Biff, but couldn't get it to work for me!
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Biff" wrote in message ... Hi! If these sheets are kept in a sequential order: Summary | Jan | Feb | Mar | Apr |.....................| Dec | Then in the InsertNameDefine refers to box: =Jan:Dec!$A$1:$A$31 Biff "noelalain" wrote in message ... I have for example 3 sheets January, February, Mars representing the days of the months. I would like to add a label "planning" by selecting days 1 to 31. How to make so that the name of the label planning is the same one for January, February, March. Thank you for your assistance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To add a name of label on several sheets.
I don't know how the OP wanted to implement this but it does work where "3D"
references will work: SUM, AVERAGE, MIN, MAX, SMALL, LARGE etc. Biff "Ragdyer" wrote in message ... It looks good Biff, but couldn't get it to work for me! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Biff" wrote in message ... Hi! If these sheets are kept in a sequential order: Summary | Jan | Feb | Mar | Apr |.....................| Dec | Then in the InsertNameDefine refers to box: =Jan:Dec!$A$1:$A$31 Biff "noelalain" wrote in message ... I have for example 3 sheets January, February, Mars representing the days of the months. I would like to add a label "planning" by selecting days 1 to 31. How to make so that the name of the label planning is the same one for January, February, March. Thank you for your assistance |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To add a name of label on several sheets.
I took the OP to mean that each *individual* sheet should have a range named
"Planning", since they did mention that it should "refer to the sheet in progress". This is normally accomplished on a sheet by sheet basis, and I guess I incorrectly assumed that you read the OP the same as I, and your procedure was a "shortcut" to applying a single name to numerous sheets, individually. The only "easy" way I'm aware of, is assigning a sheet specific name to the first sheet, and then as you copy this sheet and change their names, each will automatically contain this same, named, sheet specific range. So, when I mentioned that your suggestion didn't work, I was referring to my interpretation of the OP's request. Apologies. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Biff" wrote in message ... I don't know how the OP wanted to implement this but it does work where "3D" references will work: SUM, AVERAGE, MIN, MAX, SMALL, LARGE etc. Biff "Ragdyer" wrote in message ... It looks good Biff, but couldn't get it to work for me! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Biff" wrote in message ... Hi! If these sheets are kept in a sequential order: Summary | Jan | Feb | Mar | Apr |.....................| Dec | Then in the InsertNameDefine refers to box: =Jan:Dec!$A$1:$A$31 Biff "noelalain" wrote in message ... I have for example 3 sheets January, February, Mars representing the days of the months. I would like to add a label "planning" by selecting days 1 to 31. How to make so that the name of the label planning is the same one for January, February, March. Thank you for your assistance |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To add a name of label on several sheets.
when I mentioned that your suggestion didn't work, I was referring to my
interpretation Different interpretations are a good thing! I'm sure you've seen where different interpretations can lead to extended discussions amongst us regulars while the OP is nowhere to be found! So all we can do is guess at what the OP really meant! Biff "Ragdyer" wrote in message ... I took the OP to mean that each *individual* sheet should have a range named "Planning", since they did mention that it should "refer to the sheet in progress". This is normally accomplished on a sheet by sheet basis, and I guess I incorrectly assumed that you read the OP the same as I, and your procedure was a "shortcut" to applying a single name to numerous sheets, individually. The only "easy" way I'm aware of, is assigning a sheet specific name to the first sheet, and then as you copy this sheet and change their names, each will automatically contain this same, named, sheet specific range. So, when I mentioned that your suggestion didn't work, I was referring to my interpretation of the OP's request. Apologies. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Biff" wrote in message ... I don't know how the OP wanted to implement this but it does work where "3D" references will work: SUM, AVERAGE, MIN, MAX, SMALL, LARGE etc. Biff "Ragdyer" wrote in message ... It looks good Biff, but couldn't get it to work for me! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Biff" wrote in message ... Hi! If these sheets are kept in a sequential order: Summary | Jan | Feb | Mar | Apr |.....................| Dec | Then in the InsertNameDefine refers to box: =Jan:Dec!$A$1:$A$31 Biff "noelalain" wrote in message ... I have for example 3 sheets January, February, Mars representing the days of the months. I would like to add a label "planning" by selecting days 1 to 31. How to make so that the name of the label planning is the same one for January, February, March. Thank you for your assistance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Identify Label €” More than one cell with label | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Multiple sheets selected | Excel Discussion (Misc queries) |