Custom Header and Page Breaks

[jray9242]

Excel Workbook
	A	B	C	E	F	G
1	Last Name	First Name	Agency	Assignment	Work Phone	E-Mail
2	Dog	abcd	ABC	Boss	###-###-####	someone@home.us
3	Good	abcd	ABC	Boss	###-###-####	someone@home.us
4	Cat	abcd	AFD	Boss	###-###-####	someone@home.us
5	Mouse	abcd	AFD	Boss	###-###-####	someone@home.us
6	Horse	abcd	BCS	Boss	###-###-####	someone@home.us
7	Rat	abcd	BCS	Boss	###-###-####	someone@home.us
8	Sake	abcd	BCS	Boss	###-###-####	someone@home.us
9	Lion	abcd	WEF	Boss	###-###-####	someone@home.us
10	Bull	abcd	WEF	Boss	###-###-####	someone@home.us
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, Jim Sheet2

Header: ABC

Excel Workbook
	A	B	C	E	F	G
1	Last Name	First Name	Agency	Assignment	Work Phone	E-Mail
2	Dog	abcd	ABC	Boss	###-###-####	someone@home.us
3	Good	abcd	ABC	Boss	###-###-####	someone@home.us
Sheet

Header: AFD

Excel Workbook
	A	B	C	E	F	G
1	Last Name	First Name	Agency	Assignment	Work Phone	E-Mail
4	Cat	abcd	AFD	Boss	###-###-####	someone@home.us
5	Mouse	abcd	AFD	Boss	###-###-####	someone@home.us
Sheet

 

[jray9242]

Punt