Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you create drill-down detail?
I have a summary sheet and what to click on cell and see detail from another
sheet. Can this be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you create drill-down detail?
Yes that can be done but it is a bit of work... In general here is what you
want to do. Add named ranges to your Summary sheet. We are going to check if the user double clicks anywhere withing the named range. Then based on what named range they double click on will dictate what sheet they will be navigated too. Here is some sample code for you . It does not use named ranges but I do highly recommend you use named ranges as they will make the code easier to read and it will make things easier to modify if your summary sheet changes... This code works on a new book. Place this code into Sheet1 (right click on the tab and select view code. paste the following. If you double click in either B1:Z5 or B6:Z10 you will be navigated to one of the other sheets... Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) With Sheets("Sheet1") If Not Intersect(Target, .Range("B1:Z5")) Is Nothing Then Cancel = True Sheets("Sheet2").Select ElseIf Not Intersect(Target, .Range("B6:Z10")) Is Nothing Then Cancel = True Sheets("Sheet3").Select End If End With End Sub -- HTH... Jim Thomlinson "Sandroid" wrote: I have a summary sheet and what to click on cell and see detail from another sheet. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create pivot table with master/detail data from 2 worksheets | Excel Worksheet Functions | |||
How to create drill down scope form? | Excel Programming | |||
create detail from summary data | Excel Programming | |||
how to see complete memo field in pivot table drill down detail | Excel Programming | |||
Show one total summary but have drill down to detail | Excel Discussion (Misc queries) |