+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Repeat page

  1. #1
    Registered User
    Join Date
    12-11-2009
    Location
    Pittsburgh
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Repeat page

    I have a page that has preset cells that are locked and that I am using for a Work Log, and when the Log gets full, or half way full i'd like it to automatically duplicate a sheet that has the previous cells filled, to the next page so that you don't have to re-enter or recopy the entire sheet down... so basically when the sheet is full.. it will continue to a new sheet that doesn't require cell editing? i would copy and paste the sheet down so that i don't have that problem, but when i go to print mode it prints out all the sheets that are unfilled and i don't want it to do that, since this workbook is sent via email also
    Last edited by jmo444; 12-11-2009 at 08:11 PM.

  2. #2
    Forum Contributor
    Join Date
    04-21-2007
    Location
    Lima, Peru
    MS-Off Ver
    2000, 2007, 2010
    Posts
    674

    Re: Repeat page

    Hi

    I assume that it would be better to keep all the data on one page, so why not use a macro for printing and that way you do not have to duplicate any data, for example if you have data in columns A to L

    Please Login or Register  to view this content.
    If you could give an example of how many columns you are using and which have data entered then an accurate example can be given.

    A sample illustrating the above is attached.

    regards

    Jeff
    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