Hi All:
In the spreadsheet attached, what I want to do is setup a drilldown so that if someone clicks a cell with a value in it, it will show everything that makes up that number.
So in the example attached. I want to setup the spreadsheet so that if someone double clicks cell B3, which is $2,201 then everything that makes it up...i.e cells B4, B8, B9 and B10 are shown otherwise hidden. If someone wants to double click B4 then I want cell cells A5 to B7 to show up.
Can someone please help work through this.
Thanks,
BA
In the spreadsheet attached, what I want to do is setup a drilldown so that if someone clicks a cell with a value in it, it will show everything that makes up that number.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
3 | Relay | 2201 | ||||
4 | PR1 | 500 | ||||
5 | HW | 100 | ||||
6 | SW | 200 | ||||
7 | Consulting | 200 | ||||
8 | PR2 | 678 | ||||
9 | TR1 | 567 | ||||
10 | TR2 | 456 | ||||
Sheet1 |
So in the example attached. I want to setup the spreadsheet so that if someone double clicks cell B3, which is $2,201 then everything that makes it up...i.e cells B4, B8, B9 and B10 are shown otherwise hidden. If someone wants to double click B4 then I want cell cells A5 to B7 to show up.
Can someone please help work through this.
Thanks,
BA