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. My hope is that there is some functionality that can
hyperlink the Price and then it will update another detailed tab, kind of
like a pivot table works? Can this be done? thx!
for example
Tab 1
Users: 20
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
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. My hope is that there is some functionality that can
hyperlink the Price and then it will update another detailed tab, kind of
like a pivot table works? Can this be done? thx!
for example
Tab 1
Users: 20
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