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