MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can I create a drill down

Posted by Darren on June 27, 2001 6:44 PM


I am preparing a budget template that has a column for cost code and a column for amount. Users are being asked to fill in relevent amounts against the cost code.
I would like to add the ability for the user to double click on the cell containing the amount and have this double click event open a second sheet that allows the user to detail the various components that make up the budget figure. This drill down sheet would then be saved as part of the work book and could be reviewed by any user of the budget to drill down into the detail of the budget. Make sense?
Any thoughts anyone?


Posted by Malc on June 27, 2001 8:53 PM

How about putting a view detail in a hyperlink to another sheet in the same work book and a hyperlink back again