See attached analysis of "sales of cars by country and continent".
Fairly simple stuff!
First sheet show "Sales By Country"
Second sheet is a dynamic summary of first sheet (i.e. second sheet shows sales by continent).
Third Sheet - This is the tricky bit!
Question: How do I get the third sheet to show a "drill down analysis" of the continent chosen in the "Sales By Continent" sheet.
E.g. if the user places the cursor in cell "A4" of sales by continent THEN the "Drill Down" sheet should show all the countries in this continent.