Forum Discussion
Expanding & Collapsing Sheet Tabs
I have a file with a large number of sheets. I would like to create a way to expand and collapse the tabs for ease of use. I've found an example code and file here that is what I would like to d...
Could I be so bold as to ask for an explanation of why there are so many individual sheets?
I know full well there are times when this kind of design is fully warranted; I also know that many times people create multiple sheets when there's no need, when, in fact, they're overlooking the amazing abilities of Excel to extract and summarize data from a single database on a single sheet, producing as needed summaries of histories or snapshots of data FROM that single sheet that otherwise would be on one of those many many sheets.
I know full well there are times when this kind of design is fully warranted; I also know that many times people create multiple sheets when there's no need, when, in fact, they're overlooking the amazing abilities of Excel to extract and summarize data from a single database on a single sheet, producing as needed summaries of histories or snapshots of data FROM that single sheet that otherwise would be on one of those many many sheets.
It is a pro forma excel file, so there are many different worksheets set up to create a financial model. Then I have inputted monthly accounting summaries as separate tabs, each which is referenced throughout the various sheets per month in various formulas. I would like to have all of these monthly accounting sheets collapsible, since there are so many and more for holding data. I do not want to reference other excel files because links often are broken and I'm working off the network at home due to COVID.