Drill Down
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Drill Down

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Before I post a long explanation of requirements, is there a way to 'drill down' through three or four spreadsheets, where each spreadsheet is a high level summary of the next?
    Pivot tables are good for one level, but they are a one way street, and leave the drill down as a new sheet.
    Anyone tried this in Excel? or should I grub around in the Access database tables and queries?

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Peter,

    I'm sure that this functionality could be achieved with a bit of VBA code--I have implemented this in the past for my own applications. I simply put a button on each sheet that makes the sub-sheet visible. When the sub-sheet is deselected, it is automatically returned to "invisibility," and this method supports any number of levels. But have you looked at using Excel Data Grouping or Outlining? Grouping can be done to a number of levels. Perhaps this provides what you need.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com