Nov 06 2019 11:20 AM - edited Nov 06 2019 12:42 PM
Nov 06 2019 12:31 PM
@Rilwan If you put the name field in the PivotTable Filter field, you can use the Show Report Filter Pages option, which will create a new worksheet for each name in the list.
See: https://www.excelcampus.com/pivot-tables/show-report-filter-pages/
Nov 06 2019 12:46 PM
SolutionNov 06 2019 12:46 PM
Solution