can an expert help me out with this please. I have attached a file which I would like to act like a pivot but which is not actually a pivot. When the user clicks on one of the cell I need it to drill down to the data and return the relevant rows on a new sheet.
So if there is a number 3 in cell C5, when this cell is clicked on I would like the macro to return the relevant 3 rows from the underlying data. [have shown example in attached file]
Hope this is self explanatory together with the attached file