+ Reply to Thread
Results 1 to 1 of 1

Removing Existing Page Breaks and Inserting a Page Break every third Total Line

  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    Wales
    MS-Off Ver
    Excel 2007
    Posts
    10

    Removing Existing Page Breaks and Inserting a Page Break every third Total Line

    Morning All,

    I am trying to auto format a company stock report, I have managed to get everything the way I want it even if it isn't the most efficient way of doing it. The problem I'm having is removing the existing page breaks and Inserting new a Page breaks on every third total line. the Total Lines appear at random intervals through out the document depending on How many Branches are being shown.

    Any Help that you could give me with this would be appreciated.

  2. #2
    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: Removing Existing Page Breaks and Inserting a Page Break every third Total Line

    Hi Kalvas

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the "Add Files"... button to locate your file for uploading.
    6. This will open a new window File Upload...Click "Select Files"
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the "Upload Files" button and wait until the file has uploaded.
    10. Click the "Done" Button.
    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 to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-14-2020, 09:08 PM
  2. I can't move my page breaks in Page Break Preview
    By btaft in forum Excel General
    Replies: 7
    Last Post: 05-14-2014, 09:53 AM
  3. Inserting Page Breaks in Existing Macro
    By duckbriggs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2011, 05:35 PM
  4. [SOLVED] Can I set an automatic page breaks to break every 40 lines?
    By Kennbu in forum Excel General
    Replies: 1
    Last Post: 06-15-2006, 01:10 PM
  5. adding a new page break to an existing page break
    By Edward Letendre in forum Excel General
    Replies: 1
    Last Post: 03-06-2005, 06:06 AM

Tags for this Thread

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