Drill Down

Peter Rouse · Mar 1st, 2002, 09:36 AM

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 · Mar 2nd, 2002, 02:12 PM

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.

Mar 2nd, 2002, 02:12 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	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 (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 09:36 AM	#1
Peter Rouse New Member Join Date: Feb 2002 Posts: 14	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?