Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables: Don't show data for detail, but still show subtotals | Excel Worksheet Functions | |||
If over 60, then show all detail | Excel Worksheet Functions | |||
pivot table - show ALL detail? | Excel Discussion (Misc queries) | |||
Open subtotal detail with hyperlink | Excel Programming | |||
Show detail | Excel Worksheet Functions |