Printing header that shows what is on each page...like the top of phone book pages.

[betchaann]

Is there a way to print a header that has cell contents that change for each page? I have a call log that I want to print so I have a hard copy, but I would like the date range on each page printed at the top for easy reference (the way a page in the phone book shows the first and last name on the page at the top of the page). I have my dates in column C, and I would like to have the first and last cell in column C for each printed page in the header. For example, the first page header would show 3/20/2013 - 3/22/2013, the next page header would show 3/22/2013 - 3/23/2013, etc. Is that possible?

[scott.s.fower]

post a sample book, so we can see how the pages are lined up, is it by number of rows per page, or some other method, it is definitely possible, but it is dependent on many factors