I'm no Excel expert so I need to kow if I'm using the right terminology by referring to drill downs.
I have a front sheet in a work book the data on that front sheet is calculated from many and various worksheets.
I need to be able to click on a data item (claculation result) and get t the the original data on the relevant worksheet.
Is this referred to as a drill down? How do I achieve the desired result?
Grateful for any help for the hard of thinking..
Bookmarks