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?