I'm running a report for seeding for a volleyball tournament. Each team has a unique team code. I have to get a win/loss record against the field for the report. I have been able to do this within a regular excel worksheet but it still involves repeatedly writing the same code for a new range. I used pivot tables to easily find the regular win/loss record. Is there an easy way to filter the team codes by the teams in the field within a pivot table?

Also, is there a way to copy the results of a pivot table over to a pre-made worksheet without having to just click back and forth and record it?

Thanks,
Spenser