+ Reply to Thread
Results 1 to 1 of 1

Inserting Custom Headers based on cell value upon page break

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2016
    Posts
    18

    Inserting Custom Headers based on cell value upon page break

    So we have a spreadsheet that reports back each locations activity for the month. This information has been subtotaled, and we can insert page breaks at each group but we need to also include the location number and name (which is the second row's cells (A & B) where the new page would start.


    So the first sheet would have the standard header info (obtained by the use of use header blah blah blah) but under that the first page should say "101 Region One"; page 2 would have "104 Region Four" and so on and so forth.

    I'm thinking a macro would be the best course of action but I am not that savvy enough yet to work it out on my own.
    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)

Similar Threads

  1. Removing Existing Page Breaks and Inserting a Page Break every third Total Line
    By Kalvas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2013, 05:12 AM
  2. Macro - Inserting Page Break
    By janjan_376 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-07-2013, 06:22 AM
  3. Inserting Page Break
    By jp16 in forum Excel General
    Replies: 0
    Last Post: 04-13-2012, 10:14 PM
  4. [SOLVED] Inserting A row & page break
    By Jamie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2006, 01:15 PM
  5. Custom Page Headers
    By jamess@therock in forum Excel General
    Replies: 1
    Last Post: 01-12-2005, 06:06 PM

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