I have to use this design, I do not have a choice. The workbooks are not the
same in content, only that I have different users (1100) submit a month by
month submission of his/hers daily time schedules (detailed). Every user
have different jobs and responsibilities, the only thing is - I create a
years worth of sheets for each and every provider. (A lot of work).

"Bernie Deitrick" wrote:

UCAPERSinAlaska,

Don't use monthly tabs - that is poor workbook design. Instead, use one sheet with the same data
table design, but with an additional column for month - or better yet, date - and then use filters
and/or pivot tables to view and manipulate your data.

HTH,
Bernie
MS Excel MVP


"UCAPERSinAlaska" wrote in message
...
I would like to avoid typing in each month every time I create a workbook.
I have to do individual yearly workbooks. Is there a faster way to make
monthly tabs. Example type Jan, Feb, Mar and then somehow the spreadsheet
would fill in the following monthly tabs?