+ Reply to Thread
Results 1 to 4 of 4

Layering / Drilling Down

  1. #1
    Registered User
    Join Date
    08-15-2012
    Location
    Mission Viejo, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Layering / Drilling Down

    test drill down.xlsBook1.xlsx
    I have this sheet that someone sent me sometime last year, and it's drilled down in a way that you can click on the layer you'd like to see on the left, and the appropriate rows will hide/unhide. I've attached a sample with "test data" in the sheet "test drill down".

    Now I'd like to get that same layered / drilled down functionality in a new sheet that I'm making. I've attached the workbook titled "Book1". I may not be using the correct search terms to find out how to do this, because I keep finding suggestions about using Pivot tables when searching for "Layering" or "Drill Down". I have no idea how to achieve this functionality and have been unable to reverse engineer, and the person I got the previous sheet from is no longer with our company and I have no means of getting in contact with them. I'd rather figure out how to do this on a new sheet than spend time Copying and Inserting rows into my old sheet, so I'm turning to you for help! Thanks in advance for any help!
    Last edited by GreatBambino; 10-19-2012 at 12:15 PM. Reason: Added Attachments

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Layering / Drilling Down

    Sounds like Outlining.

    http://office.microsoft.com/en-us/ex...005201641.aspx


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    08-15-2012
    Location
    Mission Viejo, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Layering / Drilling Down

    That's it!! Thank you!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Layering / Drilling Down

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1