Drill Downs

  • Thread starter Thread starter boksbox
  • Start date Start date
B

boksbox

I'm no Excel expert so I need to kow if I'm using the right terminolog
by referring to drill downs.

I have a front sheet in a work book the data on that front sheet i
calculated from many and various worksheets.

I need to be able to click on a data item (claculation result) and ge
t the the original data on the relevant worksheet.
Is this referred to as a drill down? How do I achieve the desire
result?
Grateful for any help for the hard of thinking.
 
Thanks Ron, that's very useful, I gues I'll have to learn about Pivot
Tables to make a long term elegant solution.
 
Back
Top