with Pivots I know you can click on a cell and it will bring back the data, be it a single item or if you click on a total it will bring back all the items that make up that total.
My question is, is it possible to do the same thing but without using a pivot.
so lets say I have a hidden file with all my data and I have built a table that has been grouped with totals. [in the same way as a pivot]
now lets say I click on one of the amount. I want it to bring back the items that make up that amount and put the details on a new sheet.
Possible or not.