HyperLink _ to show detail?
 

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

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

HyperLink _ to show detail?
 

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
Your link to the file: http://www.savefile.com/files/2149776


"Patrick Molloy" wrote:

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

HyperLink _ to show detail?
 

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



"H" wrote in message
...
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
Your link to the file: http://www.savefile.com/files/2149776


"Patrick Molloy" wrote:

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

HyperLink _ to show detail?
 

thank you, where should I send it?
"Patrick Molloy" wrote:

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



"H" wrote in message
...
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
Your link to the file: http://www.savefile.com/files/2149776


"Patrick Molloy" wrote:

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