HyperLink _ to show detail?

[H]

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

 

[Patrick Molloy]

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]

Hi Patrick, I created a example workbook of what I am trying to do is there
anyway you could help me create the VBA? Here's the url I found to be able
to post it somewhere .. thank you so much for your help!!! It's very
appreciated!!!

here's the URL

 

[Patrick Molloy]

send it to me directly. Norton detests a virus via the website that you use
and I won't touch it.

 

[H]

thank you, where should I send it?

send it to me directly. Norton detests a virus via the website that you use
and I won't touch it.

 

[Patrick Molloy]

my hotmail is good enough.

thank you, where should I send it?

 

[H]

Thanks! what is your hotmail acct?

my hotmail is good enough.

 

[Patrick Molloy]

its in the newsgroup - so i thought that you had it.

patrick_molloyATNOSPAMhotmail.com

edit apprpriately