HyperLink _ to show detail?
you could use the double click event or an object - both linking to some
VBA. The code would need to filter the data from your main data table for
whatever the keys are, such as Part# or whatever. A pivot table does this
already by the way - its a built in feature
"H" wrote in message
...
Hi, I am wondering if Excel has this kind of capability? In one tab I
have a
lot of calculations going on and then what is displayed is a summary at
the
bottom of the page .. I need to create another couple of tabs with the
detail
behind those results
by hopefully saying hyperlinking the Project Price and then it creating a
detailed tab, kind of like a pivot table works? Can this be done? thx!
for example
Tab 1
Users: 15
Part # abc
Part Desc
Project Price $20,000 (this is a total price)
In Tab 2 I need to break that out
Item # Part# Desc Biz Model Users List
Price
Ext Price
1 abc desc 1 biz model 1 20 500
10,000
2 def desc 2 biz model 1 20 500
10,000
Total
$20,000
|