Creating "Sub"sheets within a workbook

[ARPelzner]

Hi,
I was wondering if there was a way to create a sub sheet within a workbook under a sheet. For an example of what I am trying to do... If I were trying to create a very detailed spreadsheet to teach the ABC, I would have a separate sheet with each letter, Sheet1=A, Sheet2=B Sheet3,=C. I am trying to see if I can made a sheet within a sheet to then list all words (lets say I have 3 diff words) that begin with the letter "A" under the Sheet1=A but as a drop down so that those 3 words will each have their own tabs? If it possible to create that?
Thanks

 

[lrobbo314]

No. Not really. Why would you need to? If you have a sheet for each letter in the alphabet, why not just put the corresponding words on that sheet? So, all the A words on sheet A, B words on sheet B. Why would you need sub sheets to your main letter sheet? Having said that, something could possibly be put together to accomplish what you are talking about, but it doesn't really make sense to do that. Unless I am missing something.

 

[ARPelzner]

No. Not really. Why would you need to? If you have a sheet for each letter in the alphabet, why not just put the corresponding words on that sheet? So, all the A words on sheet A, B words on sheet B. Why would you need sub sheets to your main letter sheet? Having said that, something could possibly be put together to accomplish what you are talking about, but it doesn't really make sense to do that. Unless I am missing something.

Well, I gave you a simple example of what I need to do. Obviously the real situation is much more complicated, but essentially in my real workbook. Each of my "sub"sheets are right next to each other. This workbook already has about 50 sheets, and the information on the "sub"sheet does not need to be viewed at all times, but I need ready access to that info when need be. I do not want to hide any sheets.

 

[Rick Rothstein]

I do not want to hide any sheets.

Why? You could list your A sheet followed by its word sheets, then you B sheet followed by its word sheets, and so on, then hide all the "sub" word sheets and then reveal only those sheets for the letter you choose. All of the hiding/unhiding could be managed by VBA event code so you would not have to do anything extra to maintain the system. All you would need to do is come up with a naming system that would allow the code to recognize the sheets you want to see/not see. For example, if you main sheet for Letter A was, say, just the letter "A", then its word sheets could all start with and "A-" (it would not matter what followed it). Does that sound like something you would be interested in pursuing?

 

[lrobbo314]

Hiding sheets makes sense. Going back to the Alphabet scenario. What would be wrong with having all of the letters visible, then if you click on "A", then all you A word sheets would become visible. Then if you click on "B", the "A" sub sheets would be hidden and the "B" sub sheets would be visible.

 

[AkaTrouble]

could you not have an index sheet showing pictures of the letters and when clicked all othe sheets except for the sheet beggining A ...A1... A2... etc and the index sheet

then you could have as many sheets as you want for each letter or number

would take a little coding but sounds like is a big project so should expect a hit on time in setup stages

 

[Value4Realty]

Hi,
I was wondering if there was a way to create a sub sheet within a workbook under a sheet. For an example of what I am trying to do... If I were trying to create a very detailed spreadsheet to teach the ABC, I would have a separate sheet with each letter, Sheet1=A, Sheet2=B Sheet3,=C. I am trying to see if I can made a sheet within a sheet to then list all words (lets say I have 3 diff words) that begin with the letter "A" under the Sheet1=A but as a drop down so that those 3 words will each have their own tabs? If it possible to create that?
Thanks

You asked a basic and reasonable question and the responses were rude and dismissive. I get what you mean. You want to organize just like folders within folders in explorer or finder. You want to click a sheet tab at the bottom and then have sub tabs come up. I wanted to do the same. I wanted 51 tabs for the 50 states and DC and then when you click say NJ it would show tabs for Atlantic County, Bergen County, etc. I don't think excel does that but it should.

 

[MARK858]

I wanted to do the same. I wanted 51 tabs for the 50 states and DC and then when you click say NJ it would show tabs for Atlantic County, Bergen County, etc. I don't think excel does that but it should.

You could do that by putting code to unhide the relevant hidden sheets (as proposed) in a Worksheet.Activate event.

 

[lrobbo314]

I don't have any idea what @Value4Realty is talking about. The OP asked a question and we gave answers. No one called names or put anyone down. And as @MARK858 points out, the advice that was given was sound.

But thanks for signing up to the forum to make a drive by, white knight, virtue signaling, accusation against members who dedicate a lot of time and effort to help people. Not sure if you were talking about me or @Rick Rothstein , but that's totally uncalled for. I've received a lot of thanks for my efforts and Rick has to be one of the most knowledgeable and well respected members on this forum.

 

[kade141141]

Hello @Irobbo314, is there a way to have a yearly folder/sheet when clicked on opens up to several sheets of all the months? I am trying to create an excel system that is calendar-based, and I am scheduling 10-15 years from now so the years 2030-2035. Is there a way to do that? Or will I have to have several excel workbooks that are labeled as years that are broken down into month sheets?