Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    We have a worksheet that has rows repeating on all the pages. The last page contains the notes for the document. We would prefer to not have the rows repeat on the last page. Can this be set up to work for the last page no matter the number of pages in the sheet area?

    We can do this manually or set up a report using Report Manager, but I just wondered if there is another way.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    An easy solution would be to move the notes to a separate sheet maybe called Notes.
    Then just remember to make the appropriate selection on the Print menu when printing to insure that the Notes sheet is printed or not as needed.

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    I like the idea of moving the notes to another worksheet, but my customer doesn't think everyone will know to print all the worksheets and therefore miss the notes.

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Quote Originally Posted by bjg1 View Post
    I like the idea of moving the notes to another worksheet, but my customer doesn't think everyone will know to print all the worksheets and therefore miss the notes.
    You could provide a button or add an option to the menus that will call a short VBA program to ask the user if the notes are needed then either print the notes or not depending on the answer.

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •