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!
Bookmarks