View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sanjiyan_s11 sanjiyan_s11 is offline
external usenet poster
 
Posts: 1
Default Various different page headers for one sheet

Is it possible to set up different page headers for one sheet? I have page
breaks so that data belonging to different codes print on separate pages. I'd
now like to add the code and it's description to the header for each page. I
expect I need to set up a macro but am not sure of the best way to do it.

I'd rather not chop up the sheet as the workbook is already large, with
multiple sheets.