I hope asking 2 questions in 1 is ok.

Here is what I need to be able to do.

1. Create a page break when the "Agency" field changes.
2. Create a custom header using the "Agency" Field.

So page break 1 will have ABC then AFD, etc.
Also, I want to field "Agency" as part of the header.

Thank you,

Sheet2


A B C E F G
1 Last Name First Name Agency Assignment Work Phone E-Mail
2 Dog abcd ABC Boss ###-###-#### [email protected]
3 Good abcd ABC Boss ###-###-#### [email protected]
4 Cat abcd AFD Boss ###-###-#### [email protected]
5 Mouse abcd AFD Boss ###-###-#### [email protected]
6 Horse abcd BCS Boss ###-###-#### [email protected]
7 Rat abcd BCS Boss ###-###-#### [email protected]
8 Sake abcd BCS Boss ###-###-#### [email protected]
9 Lion abcd WEF Boss ###-###-#### [email protected]
10 Bull abcd WEF Boss ###-###-#### [email protected]er: ABC


A B C E F G
1 Last Name First Name Agency Assignment Work Phone E-Mail
2 Dog abcd ABC Boss ###-###-#### [email protected]
3 Good abcd ABC Boss ###-###-#### [email protected]


Header: AFD

A B C E F G
1 Last Name First Name Agency Assignment Work Phone E-Mail
4 Cat abcd AFD Boss ###-###-#### [email protected]
5 Mouse abcd AFD Boss ###-###-#### [email protected]