Sub-Worksheets

[Mike Clark]

I started an Excel file at the beginning of the year, with one worksheet per month, a total of twelve worksheet. Instead of creating a new file for 2006, I wondered if there was any way to put all these worksheets in a "folder" of sorts, and begin a new "folder" with 12 new months in it, all within the same file. Is this or any other similar ideas possible?

 

[Norie]

Mike

I don't think this is possible, but I don't 100% get what you mean.

If you don't want to create the new file from scratch just copy last year's workbook, remove all the data and save under another name.

 

[Mike Clark]

Sounds like you understand it. Basically, I just wondered if there was an kind of heirarchy within worksheets. I will probably have to keep these as individual files for each year (there are about 60 years total, and I was just looking for a way to combine them). Thanks very much though.