I have a spread sheet with the following information.

A: Last Name
B: First Name
C: Agency

What I want to do is the following when I print:
1. Create a page break every time "Agency" changes
2. Show the "Agency" name in the header row.

Example.

Ray, Sam, ABC
Ding, Dong, ABC
My, Name, BCA
Your, Name, BCA

Print Report:

Header: ABC
Ray, Sam, ABC
Ding, Dong, ABC

Header: BCA
My, Name, BCA
Your, Name, BCA

I hope this makes sense and thank you.