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