how do I auto name worksheets in Excel?
hi there
I want to auto name my worksheets in Excel. Eg: Name the first shet January,
nrext sheet February, then have Excel auto name the remaining ten sheets with
the remaining months of the year.
This is similar to the auto fill function where cells can be filled
automatically, but I cannot work out how to name worksheets this way.
Does anyone know if this can be done, and if so, how?
thanks
Kathryn
|