+ Reply to Thread
Results 1 to 1 of 1

Heading based on page break

  1. #1
    Registered User
    Join Date
    02-09-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Heading based on page break

    Hello all,

    I have a schedule similar to the example attached:

    I have a page break at each change in individual and wonder if there was any way that I could use a formula in the heading so i could have the individual's name automatically update when printing the report?

    So for John Smith's schedule 'John Smith' appears under the report name at the top of the report then on the next page on Paul Robinson's schedule, 'Paul Robinson' appears under the report name.

    There is the potential that there might be more than one page for each individual.

    Any help will be hugely appreciated.

    Thanks in advance
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1