HyperLink _ to show detail?

H

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
 
P

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

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
 
P

Patrick Molloy

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

Patrick Molloy

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

patrick_molloyATNOSPAMhotmail.com

edit apprpriately
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top