ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I customise my headers so they are all different? (https://www.excelbanter.com/excel-discussion-misc-queries/245207-how-can-i-customise-my-headers-so-they-all-different.html)

atomdunjey

How can I customise my headers so they are all different?
 
I am trying to make a diary and would like the header on the even pages to
say Term 1 Week 1 then Term 1 Week 2 etc but because there are also odd
pages it can only put page numbers in so it becomes Week 2 then Week 4 etc

Dave Peterson

How can I customise my headers so they are all different?
 
I don't understand the pattern you want to use, but Ron de Bruin has a macro
that changes the print titles for page 1 and page 2-???.

http://www.rondebruin.nl/print.htm#not

I bet it could be modified to do what you want...

atomdunjey wrote:

I am trying to make a diary and would like the header on the even pages to
say Term 1 Week 1 then Term 1 Week 2 etc but because there are also odd
pages it can only put page numbers in so it becomes Week 2 then Week 4 etc


--

Dave Peterson


All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com