software

I have for example 3 sheets January, February, Mars representing the days of
the months. I would like to add a label quot;planningquot; 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

Hi!

If these sheets are kept in a sequential order:

Summary | Jan | Feb | Mar | Apr |.....................| Dec |

Then in the Insertgt;Namegt;Define refers to box:

=Janec!$A$1:$A$31

Biff

quot;noelalainquot; gt; wrote in message
...
gt;
gt; I have for example 3 sheets January, February, Mars representing the days
gt; of
gt; the months. I would like to add a label quot;planningquot; by selecting days 1 to
gt; 31.
gt; How to make so that the name of the label planning is the same one for
gt; January, February, March.
gt; Thank you for your assistance
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 !
---------------------------------------------------------------------------
quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; If these sheets are kept in a sequential order:
gt;
gt; Summary | Jan | Feb | Mar | Apr |.....................| Dec |
gt;
gt; Then in the Insertgt;Namegt;Define refers to box:
gt;
gt; =Janec!$A$1:$A$31
gt;
gt; Biff
gt;
gt; quot;noelalainquot; gt; wrote in message
gt; ...
gt; gt;
gt; gt; I have for example 3 sheets January, February, Mars representing the
days
gt; gt; of
gt; gt; the months. I would like to add a label quot;planningquot; by selecting days 1
to
gt; gt; 31.
gt; gt; How to make so that the name of the label planning is the same one for
gt; gt; January, February, March.
gt; gt; Thank you for your assistance
gt;
gt;I don't know how the OP wanted to implement this but it does work where quot;3Dquot;
references will work:

SUM, AVERAGE, MIN, MAX, SMALL, LARGE etc.

Biff

quot;Ragdyerquot; gt; wrote in message
...
gt; It looks good Biff, but couldn't get it to work for me!
gt; --
gt; Regards,
gt;
gt; RD
gt;
gt; ---------------------------------------------------------------------------
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; ---------------------------------------------------------------------------
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hi!
gt;gt;
gt;gt; If these sheets are kept in a sequential order:
gt;gt;
gt;gt; Summary | Jan | Feb | Mar | Apr |.....................| Dec |
gt;gt;
gt;gt; Then in the Insertgt;Namegt;Define refers to box:
gt;gt;
gt;gt; =Janec!$A$1:$A$31
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;noelalainquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;
gt;gt; gt; I have for example 3 sheets January, February, Mars representing the
gt; days
gt;gt; gt; of
gt;gt; gt; the months. I would like to add a label quot;planningquot; by selecting days 1
gt; to
gt;gt; gt; 31.
gt;gt; gt; How to make so that the name of the label planning is the same one for
gt;gt; gt; January, February, March.
gt;gt; gt; Thank you for your assistance
gt;gt;
gt;gt;
gt;
I took the OP to mean that each *individual* sheet should have a range named
quot;Planningquot;, since they did mention that it should quot;refer to the sheet in
progressquot;.

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 quot;shortcutquot; to applying a single name to numerous sheets, individually.

The only quot;easyquot; 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 !
---------------------------------------------------------------------------

quot;Biffquot; gt; wrote in message
...
gt;I don't know how the OP wanted to implement this but it does work where
gt;quot;3Dquot; references will work:
gt;
gt; SUM, AVERAGE, MIN, MAX, SMALL, LARGE etc.
gt;
gt; Biff
gt;
gt; quot;Ragdyerquot; gt; wrote in message
gt; ...
gt;gt; It looks good Biff, but couldn't get it to work for me!
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; RD
gt;gt;
gt;gt; ---------------------------------------------------------------------------
gt;gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt;gt; ---------------------------------------------------------------------------
gt;gt; quot;Biffquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Hi!
gt;gt;gt;
gt;gt;gt; If these sheets are kept in a sequential order:
gt;gt;gt;
gt;gt;gt; Summary | Jan | Feb | Mar | Apr |.....................| Dec |
gt;gt;gt;
gt;gt;gt; Then in the Insertgt;Namegt;Define refers to box:
gt;gt;gt;
gt;gt;gt; =Janec!$A$1:$A$31
gt;gt;gt;
gt;gt;gt; Biff
gt;gt;gt;
gt;gt;gt; quot;noelalainquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt; gt;
gt;gt;gt; gt; I have for example 3 sheets January, February, Mars representing the
gt;gt; days
gt;gt;gt; gt; of
gt;gt;gt; gt; the months. I would like to add a label quot;planningquot; by selecting days 1
gt;gt; to
gt;gt;gt; gt; 31.
gt;gt;gt; gt; How to make so that the name of the label planning is the same one for
gt;gt;gt; gt; January, February, March.
gt;gt;gt; gt; Thank you for your assistance
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;
gt;gt;when I mentioned that your suggestion didn't work, I was referring to my
gt;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

quot;Ragdyerquot; gt; wrote in message
...
gt;I took the OP to mean that each *individual* sheet should have a range
gt;named quot;Planningquot;, since they did mention that it should quot;refer to the sheet
gt;in progressquot;.
gt;
gt; This is normally accomplished on a sheet by sheet basis, and I guess I
gt; incorrectly assumed that you read the OP the same as I, and your procedure
gt; was a quot;shortcutquot; to applying a single name to numerous sheets,
gt; individually.
gt;
gt; The only quot;easyquot; way I'm aware of, is assigning a sheet specific name to
gt; the first sheet, and then as you copy this sheet and change their names,
gt; each will automatically contain this same, named, sheet specific range.
gt;
gt; So, when I mentioned that your suggestion didn't work, I was referring to
gt; my interpretation of the OP's request.
gt;
gt; Apologies.
gt; --
gt; Regards,
gt;
gt; RD
gt;
gt; ---------------------------------------------------------------------------
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; ---------------------------------------------------------------------------
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt;I don't know how the OP wanted to implement this but it does work where
gt;gt;quot;3Dquot; references will work:
gt;gt;
gt;gt; SUM, AVERAGE, MIN, MAX, SMALL, LARGE etc.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Ragdyerquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; It looks good Biff, but couldn't get it to work for me!
gt;gt;gt; --
gt;gt;gt; Regards,
gt;gt;gt;
gt;gt;gt; RD
gt;gt;gt;
gt;gt;gt; ---------------------------------------------------------------------------
gt;gt;gt; Please keep all correspondence within the NewsGroup, so all may benefit
gt;gt;gt; !
gt;gt;gt; ---------------------------------------------------------------------------
gt;gt;gt; quot;Biffquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Hi!
gt;gt;gt;gt;
gt;gt;gt;gt; If these sheets are kept in a sequential order:
gt;gt;gt;gt;
gt;gt;gt;gt; Summary | Jan | Feb | Mar | Apr |.....................| Dec |
gt;gt;gt;gt;
gt;gt;gt;gt; Then in the Insertgt;Namegt;Define refers to box:
gt;gt;gt;gt;
gt;gt;gt;gt; =Janec!$A$1:$A$31
gt;gt;gt;gt;
gt;gt;gt;gt; Biff
gt;gt;gt;gt;
gt;gt;gt;gt; quot;noelalainquot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt; gt;
gt;gt;gt;gt; gt; I have for example 3 sheets January, February, Mars representing the
gt;gt;gt; days
gt;gt;gt;gt; gt; of
gt;gt;gt;gt; gt; the months. I would like to add a label quot;planningquot; by selecting days
gt;gt;gt;gt; gt; 1
gt;gt;gt; to
gt;gt;gt;gt; gt; 31.
gt;gt;gt;gt; gt; How to make so that the name of the label planning is the same one
gt;gt;gt;gt; gt; for
gt;gt;gt;gt; gt; January, February, March.
gt;gt;gt;gt; gt; Thank you for your assistance
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;