Drill Downs

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.
 
B

boksbox

Thanks Ron, that's very useful, I gues I'll have to learn about Pivot
Tables to make a long term elegant solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table drill down sort 0
Pivot table drill down data 2
Excel 2007 pivot table using analysis services cube as data source 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Drill down pivot table data via VBA macro 6
Drill down to new window instead of worksheet 2
VBA Dynamic range in Pivot table 0
Show search results within form + drill down to detail form 2

Top