way to create named tab sheets

[sam__gleeson]

Hi

I have a workbook which needs a new sheet for each day of the month.I normally just create and re-name each sheet with the date...is there a simpler way where i can create the new sheet with a date for each month instead of doing indiviually?

Thanks
Excel 2010

 

[sam__gleeson]

Hi Dave

Works well but if i have say February it places all in order but if i then select April it places the first 3 from april in front of February and the rest of the month after february.....can it be done say with a listbox/userform where you select from January to December which or all months and places in order

Thanks again

 

[dmt32]

Hi Dave

Works well but if i have say February it places all in order but if i then select April it places the first 3 from april in front of February and the rest of the month after february.....can it be done say with a listbox/userform where you select from January to December which or all months and places in order

Thanks again

Hi Sam,
sounds like made some progress - can be done with userform / listbox to populate all you need do is something like this:

Private Sub UserForm_Initialize()
    Dim i As Integer
    For i = 1 To 12
    Me.ListBox1.AddItem MonthName(i, False)
Next i
End Sub

you are getting the ordering problem because the first 3 sheets are renamed with selected month & then new sheets added. Seems like I have not fully understood what you are doing.

I am a bit pre-occupied resolving storm damage issues at moment & don't have too much time to spend on board. If you want to PM me with copy of your workbook, will have a look when I can. Alternatively, you can start a new thread & someone here be able to assist you.

Dave.