How do I create subworksheets within a worksheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jill DeLong - 21 Jan 2008 00:45 GMT

I have 5 main categories (worksheets) in one workbook. Within each main
category, I have sub categories that I would like to organize in seperate
worksheets. Ideally, I'd like only the 5 main worksheets to show and when
one is clicked on, the subworksheets appear. Is this possible?

Reply to this Message

CLR - 21 Jan 2008 18:02 GMT

Working from sheet set up as a "MainMenu", you could hide and unhide the
sheets so that only the ones relative to your interest appear. This would
require VBA. If you are still interested post back and someone will help

Vaya con Dios,
Chuck, CABGx3

> I have 5 main categories (worksheets) in one workbook. Within each main
> category, I have sub categories that I would like to organize in seperate
> worksheets. Ideally, I'd like only the 5 main worksheets to show and when
> one is clicked on, the subworksheets appear. Is this possible?

Reply to this Message

rmontenegro - 26 Feb 2008 16:38 GMT

I am interested in completing a set up of this nature for a series of reports
that I am working on. I would love to see main worksheets, once selected,
that would include subworksheets of related data. Would you be able to send
me the steps to walk me through set up? I'm on Excel 2007 w/ VBA capabilities.

Thanks - Rmontenegro

>Working from sheet set up as a "MainMenu", you could hide and unhide the
>sheets so that only the ones relative to your interest appear. This would
[quoted text clipped - 7 lines]
>> worksheets. Ideally, I'd like only the 5 main worksheets to show and when
>> one is clicked on, the subworksheets appear. Is this possible?

Reply to this Message

Mc/ - 02 Feb 2008 21:55 GMT

Your request is where I make use of the Outline or Grouping feature.
This will place a +/- icon to the left of the rows or columns, where you can
click on the + to expand the view to see the contents or click on the - to
collapse the view and hide the contents.

Reply to this Message

Rate this thread: