I created a pivot table from a master data list and have a bunch of businesses with all of the data related to that business. The data in the pivot table is sorted by business name and number of stores. I want to be choose all the stores with 10 or more locations and be able to "show details" (where it opens another worksheet with all the data from the master list for the selected items). I have been highlighting multiple selections and clicking "show details" but it has only been extracting the first highlighted business.