+ Reply to Thread
Results 1 to 12 of 12

Insert title by pagebreak in a certain cell value

  1. 08-10-2013, 11:43 AM #1
    Danielle22
    Danielle22 is offline
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Insert title by pagebreak in a certain cell value

    Hi all,

    It Is also possible when the values at the pagebreaks are higher than 100000 that then the title is added?

    See my example.

    I do it now all manually. But it is also possible with VBA?

    Thanks for any comments.

    Greetings,

    Danielle
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-11-2013, 08:58 AM #2
    Danielle22
    Danielle22 is offline
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Insert title by pagebreak in a certain cell value

    Hi all,

    Does anyone know another solution?

    Regards,

    Danielle
    Reply With QuoteRegister To Reply
  3. 08-11-2013, 12:18 PM #3
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Insert title by pagebreak in a certain cell value

    Hi Danielle

    Try this 
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  4. 08-11-2013, 03:15 PM #4
    Danielle22
    Danielle22 is offline
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Insert title by pagebreak in a certain cell value

    Hi John,

    Thank you very much

    Here I am very happy with it.

    It Is also possible that the format of the titles remains the same? And merged cells in the main title?


    If that does not want to, then this is also perfect.

    Thanks

    Greetings,

    Danielle
    Reply With QuoteRegister To Reply
  5. 08-11-2013, 03:25 PM #5
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Insert title by pagebreak in a certain cell value

    Hi Danielle

    The only Format difference I see is centering the titles...that's easily accomplished. I don't know what the titles are to look like in this request.
    And merged cells in the main title
    I will tell you, I'm not a Fan of merged cells...you show me how you want it to look...I'll try to duplicate it.
    Reply With QuoteRegister To Reply
  6. 08-11-2013, 03:30 PM #6
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Insert title by pagebreak in a certain cell value

    Hi Danielle

    To accomplish the Centering of the Titles change the Code to this 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 08-11-2013, 04:38 PM #7
    Danielle22
    Danielle22 is offline
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Insert title by pagebreak in a certain cell value

    Hi John,

    Thanks for your new VBA.

    See the new annex for the original title i use.

    thanks a lot for your help.

    Greetings,

    Danielle
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 08-11-2013, 07:17 PM #8
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Insert title by pagebreak in a certain cell value

    Hi Danielle

    How does your most recent File Upload relate to what we're working on? I'm an Old Man...don't make me think that hard...show me what you have and what you'd like it to be. We'll see if we can make it happen.
    Reply With QuoteRegister To Reply
  9. 08-12-2013, 02:23 AM #9
    Danielle22
    Danielle22 is offline
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Insert title by pagebreak in a certain cell value

    Hi John,

    sorry, I have a unclear example added. At this the original file.

    It Is also possible that the format of the titles remains the same?

    Greetings,

    Danielle
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 08-12-2013, 08:50 AM #10
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Insert title by pagebreak in a certain cell value

    Hi Danielle

    Try this 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 08-12-2013, 08:58 AM #11
    Danielle22
    Danielle22 is offline
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Insert title by pagebreak in a certain cell value

    Hi John,

    Thanks you for the code!

    I am very pleased with it

    Greetings,

    Danielle
    Reply With QuoteRegister To Reply
  12. 08-12-2013, 01:26 PM #12
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Insert title by pagebreak in a certain cell value

    You're welcome...glad I could help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Insert Pagebreak Insert pagebreak in next row where value matches the value in A1
    By karissao in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2010, 12:46 PM
  2. VBA expression to insert pagebreak
    By modytrane in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-30-2008, 11:07 AM
  3. PageBreak and Insert the value in Header based on a cell value (Lookup)
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-30-2008, 02:01 PM
  4. insert pagebreak after a specific column?
    By Macroman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2006, 07:20 AM
  5. Insert contents of a cell into a title of a chart
    By greg stenzel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-20-2005, 08: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1