Sub-Worksheets

Mike Clark

Board Regular
Joined
Jul 7, 2005
Messages
120
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?
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Jul 7, 2005
Messages
120
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,088
Members
412,566
Latest member
TexasTony
Top