Drill Down

[Peter Rouse]

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?

 

[Damon Ostrander]

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.