| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
work book sheets
is there a way to name workbooksheets automatically rather than each one
individually? need to have a workbook with a sheet in it for every day of the month.. is tedious to rename all the sheets each month.. ideas? please? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
work book sheets
Hi Kathy
I have created a file with some code which does this for you. You can download a copy at http://www.contextures.com/CreateMthlyWkbks.zip -- Regards Roger Govier "kathy" wrote in message ... is there a way to name workbooksheets automatically rather than each one individually? need to have a workbook with a sheet in it for every day of the month.. is tedious to rename all the sheets each month.. ideas? please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One cell to many cells (two different work book/sheets) | Excel Discussion (Misc queries) | |||
| How do I repeat XML map in sheets of the same excel work book | Excel Discussion (Misc queries) | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| simultaneously work in a work book with other users | Excel Discussion (Misc queries) | |||
Linear Mode
