+ Reply to Thread
Results 1 to 1 of 1

Heading based on page break

  1. #1
    Registered User
    Join Date
    London, England
    MS-Off Ver
    Excel 2003

    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)


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