Hi PC-Guy ... thanks for your inputs but I'm not wanting to use a SUBTOTAL function or AUTOFILTER on the main data sheet. Like I said in my original question I need to drill down from the SUMIFS total on the report page and then have only the rows of data that were summed show up in the sheet displayed. It needs to work just like the drill down capability in a Pivot Table ... thanks!
Here you go ... thanks.
The filter on sheet1 is just an example of what the results should be -- do you know how the drill down on a pivot table works? If so I want the EXACT same capability -- I want to double click the sum in sheet 2 and have the results in sheet 1 displayed (either on sheet2 or on a new sheet like the pivot table drill down does it) but without having to have the data in a pivot table.
Yes ... I'd think by using a double click action in the cell where the SUMIFS formulas resides and it would be better to place them on a new sheet so the original stays intact after the drill down -- thanks for your help!
That's fine ... thank you!
Hey PC-Guy ... this works exactly like what I wanted! Now I want to use this capability on multiple cells -- I will have a complete report and I want the user to be able to drill down on any of the cells just like this one works. How do I transfer or use this macro in other workbooks, on other sheets and in other cells? Thanks in advance for all your help and your responsiveness!
By multiple cells I mean I'll being using SUMIFS in various cells in my final report (for instance I'd have summaries for all the various salespeople and car types in the file I sent you) and I need to be able to have the drill down capability on all of them.